本文整理汇总了C#中LANDCOMP.ExecuteSTP.List13方法的典型用法代码示例。如果您正苦于以下问题:C# ExecuteSTP.List13方法的具体用法?C# ExecuteSTP.List13怎么用?C# ExecuteSTP.List13使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类LANDCOMP.ExecuteSTP
的用法示例。
在下文中一共展示了ExecuteSTP.List13方法的9个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: ServiceSelect
private bool ServiceSelect(string sm)
{
switch (sm)
{
case "L":
var param1L = Request.Params["param1"].ToString();
var param2L = Request.Params["param2"].ToString();
var param4L = Request.Params["param4"].ToString();
var param5L = Request.Params["param5"].ToString();
LANDCOMP.ExecuteSTP eSTP_L = new LANDCOMP.ExecuteSTP();
eSTP_L.Datas();
DataSet ds_L = new DataSet();
ds_L = eSTP_L.List13("P_PENLAP", param1L, param2L, "", param4L, param5L, "", "", "", "", "", "", "", "");
dt = ds_L.Tables[0];
Response.ContentType = "application/xhtml+xml";
Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>");
Response.Write("<rows>");
groupsid = Session["groups"].ToString();
for (int i = 0; i < dt.Rows.Count; i++)
{
Random r = new Random();
Response.Write("<row id=\"" + (i + 1).ToString() + "\">");
Response.Write("<cell>" + (i + 1).ToString() + "</cell>"); // Untuk Membuat Angka
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["penlapNmrPen"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["praregNmrPra"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["MidentNamass"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["praregLokdes"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["penlapLanjut"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace("View^PengecekanLapanganForm.aspx?rand=" + r.Next() + "¶m1=V" + "¶m2=" + dt.Rows[i]["praregNmrPra"].ToString() + "") +"</cell>");
if (dt.Rows[i]["penlapNmrPen"].ToString() != "")
{
Response.Write("<cell>" + RemoveWhiteSpace("Edit^PengecekanLapanganForm.aspx?rand=" + r.Next() + "¶m1=E" + "¶m2=" + dt.Rows[i]["praregNmrPra"].ToString() + "") + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace("Delete^PengecekanLapanganForm.aspx?rand=" + r.Next() + "¶m1=D" + "¶m2=" + dt.Rows[i]["praregNmrPra"].ToString() + "") + "</cell>");
}
Response.Write("</row>");
}
Response.Write("</rows>");
dt.Dispose();
Response.End();
Response.End();
return false;
default:
Response.ContentType = "text/plain";
Response.End();
return true;
}
}
示例2: Save
private String Save()
{
if (Session["userid"] is object)
{
userid = Session["userid"].ToString();
}
String param1 = ""; if (Request.Params["param1"] is object) param1 = Request.Params["param1"].ToString();
String param2 = ""; if (Request.Params["param2"] is object) param2 = Request.Params["param2"].ToString();
String param3 = ""; if (Request.Params["param3"] is object) param3 = Request.Params["param3"].ToString();
String param4 = ""; if (Request.Params["param4"] is object) param4 = Request.Params["param4"].ToString();
String param5 = ""; if (Request.Params["param5"] is object) param5 = Request.Params["param5"].ToString();
String param6 = ""; if (Request.Params["param6"] is object) param6 = Request.Params["param6"].ToString();
String param7 = ""; if (Request.Params["param7"] is object) param7 = Request.Params["param7"].ToString();
String sql = "";
String output = "";
try
{
output = param1;
if (output == "A")
{
LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP();
eSTP.Datas();
DataSet ds = new DataSet();
ds = eSTP.List13("P_PENLAP", "X", param2, "", "", "", "", "", "", "", "", "", "", "");
dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
if (output == "E")
output = "noedit";
if (output == "D")
output = "nodelete";
if (output == "A")
output = "noadd";
return output;
}
}
if (output == "E" || output == "D" || output == "A" || output == "I")
{
LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP();
eSTP.Datas();
DataSet ds = new DataSet();
eSTP.save7("P_PERUSA", param1, param2, param3, param4, param5, userid, param7);
return output;
}
else
output = "gagal";
}
catch (Exception ex)
{
Response.Write(ex.Message);
Response.End();
return ex.Message;
}
return output;
}
示例3: ServiceSelect
private bool ServiceSelect(string sm)
{
switch (sm)
{
case "E":
Response.ContentType = "text/plain";
var param1 = Request.Params["param1"].ToString();
var param2 = Request.Params["param2"].ToString();
var param4 = Request.Params["param4"].ToString();
var param5 = Request.Params["param5"].ToString();
var param11 = Request.Params["param11"].ToString();
//var param17 = "hanny"; //session
var param12 = Session["userid"].ToString();
LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP();
eSTP.Datas();
DataSet ds = new DataSet();
eSTP.save13("P_NEGOSI", param1, param2, "", param4, param5, "", "", "", "", "", param11, param12, "");
Response.End();
return false;
case "L":
var param1L = Request.Params["param1"].ToString();
var param2L = Request.Params["param2"].ToString();
var param4L = Request.Params["param4"].ToString();
var param5L = Request.Params["param5"].ToString();
LANDCOMP.ExecuteSTP eSTP_L = new LANDCOMP.ExecuteSTP();
eSTP_L.Datas();
DataSet ds_L = new DataSet();
ds_L = eSTP_L.List13("P_NEGOSI", param1L, param2L, "", param4L, param5L, "", "", "", "", "", "", "", "");
dt = ds_L.Tables[0];
Response.ContentType = "application/xhtml+xml";
Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>");
Response.Write("<rows>");
for (int i = 0; i < dt.Rows.Count; i++)
{
Random r = new Random();
Response.Write("<row id=\"" + (i + 1).ToString() + "\">");
Response.Write("<cell>" + (i + 1).ToString() + "</cell>"); // Untuk Membuat Angka
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["negosiNmrNeg"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["registNmrReg"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["pengtoNmrPid"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["negosiSepakt"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["negosiAssign"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["Assign"].ToString()) + "</cell>");
Response.Write("</row>");
}
Response.Write("</rows>");
dt.Dispose();
Response.End();
Response.End();
return false;
default:
Response.ContentType = "text/plain";
Response.End();
return true;
}
}
示例4: ServiceSelect
private bool ServiceSelect(string sm)
{
switch (sm)
{
case "V":
var Param1 = Request.Params["param1"].ToString();
var Param2 = Request.Params["param2"].ToString();
LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP();
eSTP.Datas();
DataSet ds = new DataSet();
ds = eSTP.List13("P_PENLAP", Param1, Param2, "", "", "", "", "", "", "", "", "", "", "");
dt = ds.Tables[0];
Response.ContentType = "text/plain";
Response.Write(dt.Rows[0]["penlapNmrPen"].ToString() + "|"); //
Response.Write(dt.Rows[0]["penlapDatess"].ToString() + "|"); //1
Response.Write(dt.Rows[0]["penlapTglukr"].ToString() + "|"); //2
Response.Write(dt.Rows[0]["penlapTglJdw"].ToString() + "|"); //3
Response.Write(dt.Rows[0]["praregNmrPra"].ToString() + "|"); //4
Response.Write(dt.Rows[0]["penlapKtngan"].ToString() + "|"); //5
Response.Write(dt.Rows[0]["penlapLanjut"].ToString() + "|"); //6
Response.Write(dt.Rows[0]["PenlapEkspsi"].ToString() + "|"); //7
Response.Write(dt.Rows[0]["penlapKeteks"].ToString() + "|"); //8
Response.Write(dt.Rows[0]["penlapUserid"].ToString() + "|"); //9
Response.Write(dt.Rows[0]["penlapUserdt"].ToString() + "|"); //10
Response.Write(dt.Rows[0]["penlapAssign"].ToString() + "|"); //11
Response.Write(dt.Rows[0]["praregNmrPra"].ToString() + "|"); //12
Response.Write(dt.Rows[0]["praregLokkab"].ToString() + "|"); //13
Response.Write(dt.Rows[0]["praregLokkec"].ToString() + "|"); //14
Response.Write(dt.Rows[0]["praregLokdes"].ToString() + "|"); //15
Response.Write(dt.Rows[0]["MidentNamass"].ToString() + "|"); //16
dt.Dispose();
Response.End();
Response.End();
return false;
//return false;
case "CRUD":
Response.ContentType = "text/plain";
Response.Write(Save());
Response.End();
return false;
case "df":
Response.Clear();
string namafile = (Request.Params["filelama"] is object ? Request.Params["filelama"].ToString() : "");
String urlfile = (Request.Params["namafile"] is object ? Request.Params["namafile"].ToString() : "");
String randomfile = (Request.Params["random"] is object ? Request.Params["random"].ToString() : "");
string type = "";
switch (namafile.Substring(namafile.Length - 4))
{
case ".htm":
case ".html":
type = "text/HTML";
break;
case ".txt":
type = "text/plain";
break;
case ".doc":
case ".docx":
case ".rtf":
type = "Application/msword";
break;
case ".xls":
case ".xlsx":
type = "Application/msexcel";
break;
case ".zip":
case ".rar":
type = "application/zip";
break;
case ".pdf":
type = "application/pdf";
break;
case ".jpg":
type = "image/JPG";
break;
case ".pgn":
type = "image/PNG";
break;
case ".tif":
type = "image/tif";
break;
}
Response.AddHeader("content-disposition", "attachment;filename=" + namafile + "");
Response.ContentType = type;
Response.WriteFile(Server.MapPath(@"~/uploaddocument/" + Request.Params["namafile"].ToString().Replace("&", "&")));
Response.End();
return false;
//.........这里部分代码省略.........
示例5: ServiceSelect
private bool ServiceSelect(string sm)
{
switch (sm)
{
case "E":
Response.ContentType = "text/plain";
var param1 = Request.Params["param1"].ToString();
var param2 = Request.Params["param2"].ToString();
var param6 = Request.Params["param6"].ToString();
var param13 = Request.Params["param13"].ToString();
var param5 = Request.Params["param5"].ToString();
//var param11 = Session["userid"].ToString();
LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP();
eSTP.Datas();
DataSet ds = new DataSet();
eSTP.save13("P_PENLAP", param1, param2, "", "", param5, param6, "", "", "", "", "", "", param13);
Response.End();
return false;
case "L":
var param1L = Request.Params["param1"].ToString();
var param2L = Request.Params["param2"].ToString();
var param4L = Request.Params["param4"].ToString();
var param5L = Request.Params["param5"].ToString();
LANDCOMP.ExecuteSTP eSTP_L = new LANDCOMP.ExecuteSTP();
eSTP_L.Datas();
DataSet ds_L = new DataSet();
ds_L = eSTP_L.List13("P_PENLAP", param1L, param2L, "", param4L, param5L, "", "", "", "", "", "", "", "");
dt = ds_L.Tables[0];
Response.ContentType = "application/xhtml+xml";
Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>");
Response.Write("<rows>");
for (int i = 0; i < dt.Rows.Count; i++)
{
Random r = new Random();
Response.Write("<row id=\"" + (i + 1).ToString() + "\">");
Response.Write("<cell>" + (i + 1).ToString() + "</cell>"); // Untuk Membuat Angka
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["penlapNmrPen"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["praregNmrPra"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["MidentNamass"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["praregLokkec"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["praregLokdes"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["penlapAssign"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["Assign"].ToString()) + "</cell>");
Response.Write("</row>");
}
Response.Write("</rows>");
dt.Dispose();
Response.End();
Response.End();
return false;
default:
Response.ContentType = "text/plain";
Response.End();
return true;
}
}
示例6: ServiceSelect
private bool ServiceSelect(string sm)
{
switch (sm)
{
case "L":
var param1L = Request.Params["param1"].ToString();
var param2L = Request.Params["param2"].ToString();
LANDCOMP.ExecuteSTP eSTP_L = new LANDCOMP.ExecuteSTP();
eSTP_L.Datas();
DataSet ds_L = new DataSet();
ds_L = eSTP_L.List9("P_NEGOSI_D", param1L, param2L, "", "", "", "", "", "", "");
dt = ds_L.Tables[0];
Response.ContentType = "application/xhtml+xml";
Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>");
Response.Write("<rows>");
for (int i = 0; i < dt.Rows.Count; i++)
{
Random r = new Random();
Response.Write("<row id=\"" + (i + 1).ToString() + "\">");
Response.Write("<cell>" + (i + 1).ToString() + "</cell>"); // Untuk Membuat Angka
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["negosiDatess"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["negosiObjeks"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["negosiLuasss"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["negosiHMinta"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["negosiJHMinta"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["negosiHTawar"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["negosiJHTawar"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["Selisih"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["negosiSequen"].ToString()) + "</cell>");
Response.Write("</row>");
}
Response.Write("</rows>");
dt.Dispose();
Response.End();
Response.End();
return false;
case "V":
Response.ContentType = "text/plain";
var Param1 = Request.Params["param1"].ToString();
var Param2 = Request.Params["param2"].ToString();
LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP();
eSTP.Datas();
DataSet ds = new DataSet();
ds = eSTP.List13("P_NEGOSI", Param1, Param2, "", "", "", "", "", "", "", "", "", "", "");
dt = ds.Tables[0];
Response.ContentType = "text/plain";
Response.Write(dt.Rows[0]["negosiNmrNeg"].ToString() + "|"); //0
Response.Write(dt.Rows[0]["registNmrReg"].ToString() + "|"); //1
Response.Write(dt.Rows[0]["pengtoNmrPid"].ToString() + "|"); //2
Response.Write(dt.Rows[0]["negosiKetrgn"].ToString() + "|"); //3
Response.Write(dt.Rows[0]["negosiSepakt"].ToString() + "|"); //4
Response.Write(dt.Rows[0]["negosiSKGR"].ToString() + "|"); //5
Response.Write(dt.Rows[0]["negosiKetEks"].ToString() + "|"); //6
Response.Write(dt.Rows[0]["negosiEkseps"].ToString() + "|"); //7
Response.Write(dt.Rows[0]["minta"].ToString() + "|"); //8
Response.Write(dt.Rows[0]["tawar"].ToString() + "|"); //9
Response.Write(dt.Rows[0]["tglNego"].ToString() + "|"); //10
dt.Dispose();
Response.End();
Response.End();
return false;
case "I":
String param1 = ""; if (Request.Params["param1"] is object) param1 = Request.Params["param1"].ToString();
String param2 = ""; if (Request.Params["param2"] is object) param2 = Request.Params["param2"].ToString();
String param3 = ""; if (Request.Params["param3"] is object) param3 = Request.Params["param3"].ToString();
String param4 = ""; if (Request.Params["param4"] is object) param4 = Request.Params["param4"].ToString();
String param5 = ""; if (Request.Params["param5"] is object) param5 = Request.Params["param5"].ToString();
String param6 = ""; if (Request.Params["param6"] is object) param6 = Request.Params["param6"].ToString();
String param7 = ""; if (Request.Params["param7"] is object) param7 = Request.Params["param7"].ToString();
String param8 = ""; if (Request.Params["param8"] is object) param8 = Request.Params["param8"].ToString();
String param9 = ""; if (Request.Params["param9"] is object) param9 = Request.Params["param9"].ToString();
String sql = "";
String output = "";
LANDCOMP.ExecuteSTP eSTP_IA = new LANDCOMP.ExecuteSTP();
eSTP_IA.Datas();
eSTP_IA.save9("P_NEGOSI_D", param1, param2, param3, param4, param5, param6, param7, param8, param9);
return false;
case "CRUD":
Response.ContentType = "text/plain";
Response.Write(Save());
Response.End();
return false;
default:
Response.ContentType = "text/plain";
Response.End();
return true;
//.........这里部分代码省略.........
示例7: Save
private String Save()
{
//string strCon = System.Configuration.ConfigurationManager.ConnectionStrings["ConStrLANDCOMPLocal2"].ToString();
//conn2 = new Connection(strCon);
String param1 = ""; if (Request.Params["param1"] is object) param1 = Request.Params["param1"].ToString();
String param2 = ""; if (Request.Params["param2"] is object) param2 = Request.Params["param2"].ToString();
String param3 = ""; if (Request.Params["param3"] is object) param3 = Request.Params["param3"].ToString();
String param4 = ""; if (Request.Params["param4"] is object) param4 = Request.Params["param4"].ToString();
String param5 = ""; if (Request.Params["param5"] is object) param5 = Request.Params["param5"].ToString();
String param6 = ""; if (Request.Params["param6"] is object) param6 = Request.Params["param6"].ToString();
String param7 = ""; if (Request.Params["param7"] is object) param7 = Request.Params["param7"].ToString();
String param8 = ""; if (Request.Params["param8"] is object) param8 = Request.Params["param8"].ToString();
String param9 = ""; if (Request.Params["param9"] is object) param9 = Request.Params["param9"].ToString();
String param10 = ""; if (Request.Params["param10"] is object) param10 = Request.Params["param10"].ToString();
String param11 = ""; if (Request.Params["param11"] is object) param11 = Request.Params["param11"].ToString();
String param12 = ""; if (Request.Params["param12"] is object) param12 = Request.Params["param12"].ToString();
String param13 = ""; if (Request.Params["param13"] is object) param13 = Request.Params["param13"].ToString();
//String sql = "";
String output = "";
try
{
output = param1;
if (output == "E" || output == "D" || output == "A")
{
LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP();
eSTP.Datas();
DataSet ds = new DataSet();
ds = eSTP.List13("P_NEGOSI", "X", param2, "", "", "", "", "", "", "", "", "", "", "");
dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
if (output == "E")
output = "noedit";
if (output == "D")
output = "nodelete";
if (output == "A")
output = "noadd";
return output;
}
}
if (output == "I" || output == "E" || output == "D")
{
LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP();
eSTP.Datas();
DataSet ds = new DataSet();
eSTP.save13("P_NEGOSI", param1, param2, param3, param4, param5, param6, param7, param8, param9, param10, param11, param12, param13);
return output;
}
else
output = "gagal";
}
catch (Exception ex)
{
Response.Write(ex.Message);
Response.End();
return ex.Message;
}
return output;
}
示例8: ServiceSelect
private bool ServiceSelect(string sm)
{
switch (sm)
{
case "L":
var param1L = Request.Params["param1"].ToString();
var param2L = Request.Params["param2"].ToString();
var param4L = Request.Params["param4"].ToString();
var param5L = Request.Params["param5"].ToString();
LANDCOMP.ExecuteSTP eSTP_L = new LANDCOMP.ExecuteSTP();
eSTP_L.Datas();
DataSet ds_L = new DataSet();
ds_L = eSTP_L.List13("P_NEGOSI", param1L, param2L, "", param4L, param5L, "", "", "", "", "", "", "", "");
dt = ds_L.Tables[0];
Response.ContentType = "application/xhtml+xml";
Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>");
Response.Write("<rows>");
groupsid = Session["groups"].ToString();
for (int i = 0; i < dt.Rows.Count; i++)
{
Random r = new Random();
Response.Write("<row id=\"" + (i + 1).ToString() + "\">");
Response.Write("<cell>" + (i + 1).ToString() + "</cell>"); // Untuk Membuat Angka
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["negosiNmrNeg"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["registNmrReg"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["pengtoNmrPid"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["negosiAssign"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["negosiSepakt"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace("View^NegosiasiForm.aspx?rand=" + r.Next() + "¶m1=V" + "¶m2=" + dt.Rows[i]["registNmrReg"].ToString() + "") + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace("Edit^NegosiasiForm.aspx?rand=" + r.Next() + "¶m1=E" + "¶m2=" + dt.Rows[i]["registNmrReg"].ToString() + "") + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace("Delete^NegosiasiForm.aspx?rand=" + r.Next() + "¶m1=D" + "¶m2=" + dt.Rows[i]["registNmrReg"].ToString() + "") + "</cell>");
Response.Write("</row>");
}
Response.Write("</rows>");
dt.Dispose();
Response.End();
Response.End();
return false;
default:
Response.ContentType = "text/plain";
Response.End();
return true;
}
}
示例9: ServiceSelect
//.........这里部分代码省略.........
dt = ds_LH.Tables[0];
Response.ContentType = "text/plain";
Response.Write(dt.Rows[0]["minta"].ToString() + "|"); //8
Response.Write(dt.Rows[0]["tawar"].ToString() + "|"); //9
dt.Dispose();
Response.End();
return false;
case "NK":
var Param2dd = Request.Params["param2"].ToString();
query = @"SELECT DISTINCT negosiNegoKe
FROM NEGOSI_D a
INNER JOIN NEGOSI b
ON a.negosiNmrNeg = b.negosiNmrNeg
WHERE b.negosiNmrNeg = '" + Param2dd + "'";
dt = getDataTable(query);
if (dt.Rows.Count > 0)
{
ddNegosiasi.Items.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
ddNegosiasi.Items.Add(new ListItem(dt.Rows[i]["negosiNegoKe"].ToString(), dt.Rows[i]["negosiNegoKe"].ToString()));
}
}
dt.Dispose();
return false;
case "V":
Response.ContentType = "text/plain";
var Param1 = Request.Params["param1"].ToString();
var Param2 = Request.Params["param2"].ToString();
LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP();
eSTP.Datas();
DataSet ds = new DataSet();
ds = eSTP.List13("P_NEGOSI", Param1, Param2, "", "", "", "", "", "", "", "", "", "", "");
dt = ds.Tables[0];
Response.ContentType = "text/plain";
Response.Write(dt.Rows[0]["negosiNmrNeg"].ToString() + "|"); //0
Response.Write(dt.Rows[0]["registNmrReg"].ToString() + "|"); //1
Response.Write(dt.Rows[0]["pengtoNmrPid"].ToString() + "|"); //2
Response.Write(dt.Rows[0]["negosiKetrgn"].ToString() + "|"); //3
Response.Write(dt.Rows[0]["negosiSepakt"].ToString() + "|"); //4
Response.Write(dt.Rows[0]["negosiSKGR"].ToString() + "|"); //5
Response.Write(dt.Rows[0]["negosiKetEks"].ToString() + "|"); //6
Response.Write(dt.Rows[0]["negosiEkseps"].ToString() + "|"); //7
Response.Write(dt.Rows[0]["minta"].ToString() + "|"); //8
Response.Write(dt.Rows[0]["tawar"].ToString() + "|"); //9
Response.Write(dt.Rows[0]["tglNego"].ToString() + "|"); //10
Response.Write(dt.Rows[0]["negosiNegoKe"].ToString() + "|"); //11
//isiNegoKe();
dt.Dispose();
Response.End();
return false;
case "I":
String param1 = ""; if (Request.Params["param1"] is object) param1 = Request.Params["param1"].ToString();
String param2 = ""; if (Request.Params["param2"] is object) param2 = Request.Params["param2"].ToString();
String param3 = ""; if (Request.Params["param3"] is object) param3 = Request.Params["param3"].ToString();
String param4 = ""; if (Request.Params["param4"] is object) param4 = Request.Params["param4"].ToString();
String param5 = ""; if (Request.Params["param5"] is object) param5 = Request.Params["param5"].ToString();
String param6 = ""; if (Request.Params["param6"] is object) param6 = Request.Params["param6"].ToString();
String param7 = ""; if (Request.Params["param7"] is object) param7 = Request.Params["param7"].ToString();
String param8 = ""; if (Request.Params["param8"] is object) param8 = Request.Params["param8"].ToString();
String param9 = ""; if (Request.Params["param9"] is object) param9 = Request.Params["param9"].ToString();
String sql = "";
String output = "";
LANDCOMP.ExecuteSTP eSTP_IA = new LANDCOMP.ExecuteSTP();
eSTP_IA.Datas();
eSTP_IA.save9("P_NEGOSI_D", param1, param2, param3, param4, param5, param6, param7, param8, param9);
return false;
case "CRUD":
Response.ContentType = "text/plain";
Response.Write(Save());
Response.End();
return false;
default:
Response.ContentType = "text/plain";
Response.End();
return true;
}
}