// POST api/<controller> public string Post([FromBody] object value) { var jd = JObject.Parse(value.ToString()); string result = string.Empty; string nt = DateTime.Now.ToString("yyyy-MM-dd HH:mm"); DateTime cd = Convert.ToDateTime((string)jd["chk_date"]); string cdStr = cd.ToString("yyyy-MM-dd"); try { if ((string)jd["updMode"] == "s")//開始 { //5 cc1.connectionofc008_modify(string.Format(@" update chkList set starttime='{0}' where sno='{1}' and hand_order='{2}' and coordsID='{3}' and chk_date='{4}' ", nt, (string)jd["sno"], (string)jd["hand_order"], (string)jd["coordsID"], cdStr)); } else//完成 { //7 cc1.connectionofc008_modify(string.Format(@" update chkList set endtime='{0}',totaltime='{1}',comstatus='{2}' where sno='{3}' and hand_order='{4}' and coordsID='{5}' and chk_date='{6}' ", nt, (string)jd["totaltime"], "1", (string)jd["sno"], (string)jd["hand_order"], (string)jd["coordsID"], cdStr)); } } catch (Exception ex) { result = ex.ToString(); } return(result); }
// POST api/<controller> public string Post([FromBody] object value) { string upStr = ""; var updatas = JObject.Parse(value.ToString()); foreach (var n in updatas["upds"]) { upStr += "update ecsfc932_ud set errdsca='" + (string)n["errdsca"] + "',type='" + (string)n["kindval"] + "',lostno='" + (string)n["lostno"] + "' where errno='" + (string)n["errno"] + "';"; } cc1.connectionofc008_modify(upStr); return(upStr); }
protected void InsertBtn_Click(object sender, EventArgs e) { Button ibtn = (Button)sender; DetailsView d2 = (DetailsView)ibtn.FindControl("DetailsView1"); Label llll = (Label)d2.FindControl("Label_errno"); TextBox tbx1 = (TextBox)d2.FindControl("TextBox1"); DropDownList ddlist2 = (DropDownList)d2.FindControl("DropDownList2"); //IconNum:6 positive、5 negative try { if (llll.Text == "" || tbx1.Text == "") { throw new ArgumentNullException(); } cc1.connectionofc008_modify("insert into ecsfc932_ud(errno,errdsca,type) values('" + llll.Text + "','" + tbx1.Text + "','" + ddlist2.SelectedValue + "')"); GridView2.DataSourceID = "SqlDataSource1"; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "nulltip2", "nulltip2('新增成功!!',6)", true); } catch (ArgumentNullException ex) { ScriptManager.RegisterStartupScript(Page, Page.GetType(), "nulltip2", "nulltip2('欄位不可有空!!',5)", true); } catch (SqlException sqlexcp) { //用replace替換掉exception陳述式中出現的換行符號\r\n //以避免javascript因判斷不出字元而導致function出錯 string SqlExcpStr = sqlexcp.Message.Replace(Environment.NewLine, ""); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "nulltip2", "nulltip2('" + SqlExcpStr + "',5)", true); } }
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { int index = Convert.ToInt32(e.CommandArgument); GridViewRow row = GridView1.Rows[index]; string ddj = Convert.ToDateTime(cc1.time_now).ToString("yyyy-MM-dd HH:mm"); string pristr1 = cc1.getcolumnindexbyname(row, "cprj"); string pristr2 = cc1.getcolumnindexbyname(row, "line"); string pristr3 = cc1.getcolumnindexbyname(row, "nopr"); string pristr4 = cc1.getcolumnindexbyname(row, "puid"); string stop_status = cc1.getcolumnindexbyname(row, "workstop"); string position = cc1.getcolumnindexbyname(row, "position"); string usdtimstr = Convert.ToDateTime(cc1.connectionofc008_select("select usdtim from ecsfc930_pud where cprj='" + pristr1 + "' and line='" + pristr2 + "' and nopr='" + pristr3 + "' and puid='" + pristr4 + "'", "usdtim")).ToString("yyy-MM-dd HH:mm"); Button ssb1 = (Button)e.CommandSource; GridViewRow myrow = (GridViewRow)ssb1.NamingContainer; TextBox tb = (TextBox)GridView1.Rows[myrow.RowIndex].Cells[9].FindControl("tbpdsca"); Button upd = (Button)GridView1.Rows[myrow.RowIndex].Cells[10].FindControl("End_exception"); if (e.CommandName == "End_exception") { //if (tb.Text != "") //{ string ssStatus = "1"; //1進行中 0休停中 if (stop_status == "是") { cc1.connectionofc008_modify("update ecsfc929_memb set code=NULL,statuscode='5' where cprj='" + pristr1 + "' and line='" + pristr2 + "' and nopr='" + pristr3 + "'"); ssStatus = "0"; } else { cc1.connectionofc008_modify("update ecsfc929_memb set statuscode='1' where cprj='" + pristr1 + "' and line='" + pristr2 + "' and nopr='" + pristr3 + "'"); } cc1.connectionofc008_modify(@"update ecsfc930_pud set [workstop]='0',uclose='是',uedtim='" + ddj + "',eutm='" + cc1.calculate_time(usdtimstr, ddj) + "',pdsca='" + tb.Text + "' where cprj='" + pristr1 + "' and line='" + pristr2 + "' and nopr='" + pristr3 + "' and puid='" + pristr4 + "';"); string uCt = cc1.connectionofc008_select(" select count(*) as uCt from ecsfc930_pud where line='" + pristr2 + "' and uclose='否'", "uCt"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "sendMsgtoKanban", "ssStatus = '" + ssStatus + "';position='" + position + "';eClose='" + uCt + "';$('#msgBtn').click();", true); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "layer_close222", "parent.location.reload();", true); //} //else //{ // //upd.Attributes.Add("onclick", "nulltip2();"); // ScriptManager.RegisterStartupScript(Page, Page.GetType(), "nulltip2", "nulltip2();", true); // //System.Threading.Thread.Sleep(5000); // //Response.Redirect(Request.Url.ToString()); //} } }
// POST api/<controller> public string Post([FromBody] object value) { var jd = JObject.Parse(value.ToString()); int status = Convert.ToInt32((string)jd["status"]); string cprj = (string)jd["cprj"]; string line = (string)jd["line"]; string nopr = (string)jd["nopr"]; string errno = (string)jd["errno"]; //dt、workstop switch (status) { //不停工異常 case 4: cc1.connectionofc008_modify(string.Format("insert into ecsfc930_pud(cprj,line,nopr,usdtim,errno,WorkStop) values('{0}','{1}','{2}','{3}','{4}','0')", cprj, line, nopr, DateTime.Now.ToString("yyyy-MM-dd HH:mm"), errno)); cc1.connectionofc008_modify(string.Format("update ecsfc929_memb set statuscode='4' where cprj='{0}' and line= '{1}' and nopr='{2}'", cprj, line, nopr)); break; //停工異常(進行中) case 3: cc1.connectionofc008_modify(string.Format("insert into ecsfc930_pud(cprj,line,nopr,usdtim,errno,WorkStop) values('{0}','{1}','{2}','{3}','{4}','1')", cprj, line, nopr, DateTime.Now.ToString("yyyy-MM-dd HH:mm"), errno)); string msfid = cc1.connectionofc008_select(string.Format("select top 1 msfid from ecsfc933_mdt where cprj='{0}' and line='{1}' and nopr='{2}' order by msfid desc", cprj, line, nopr), "msfid"); this.cc1.connectionofc008_modify(string.Format(@"update ecsfc933_mdt set edate='{0}',edtim='{1}' where msfid='{2}'", DateTime.Now.ToString("yyyy-MM-dd"), DateTime.Now.ToString("HHmm"), msfid)); int countofgroup933 = Convert.ToInt32(cc1.connectionofc008_select(string.Format("select count(*) as cot from ecsfc933_mdt where cprj='{0}' and line='{1}' and nopr='{2}'", cprj, line, nopr), "cot")); int totalm = connectionofc008_selectarray(string.Format("select sdate,stuff(right('0000'+cast(sdtim as nvarchar),4),3,0,':') as sdt,edate,stuff(right('0000'+cast(edtim as nvarchar),4),3,0,':') as edt from ecsfc933_mdt where cprj='{0}' and line='{1}' and nopr='{2}'", cprj, line, nopr), countofgroup933); this.cc1.connectionofc008_modify(string.Format("update ecsfc929_memb set autm='" + totalm + "',statuscode='3' where cprj='{0}' and line='{1}' and nopr='{2}'", cprj, line, nopr)); break; //停工異常(休停中) default: cc1.connectionofc008_modify(string.Format("insert into ecsfc930_pud(cprj,line,nopr,usdtim,errno,WorkStop) values('{0}','{1}','{2}','{3}','{4}','1')", cprj, line, nopr, DateTime.Now.ToString("yyyy-MM-dd HH:mm"), errno)); this.cc1.connectionofc008_modify(string.Format("update ecsfc929_memb set statuscode='3' where cprj='{0}' and line='{1}' and nopr='{2}'", cprj, line, nopr)); break; } return(""); }
// POST api/<controller> public string Post([FromBody] object value) { StringBuilder upStr = new StringBuilder(); var updatas = JObject.Parse(value.ToString()); foreach (var n in updatas["upds"]) { //upStr.Append(@"update rp3440.baan.baan.tecsfc915230 set t_dsca='" + (string)n["t_dsca"] + "' where t_cprj='" + (string)n["t_cprj"] + "';"); upStr.Append(string.Format(@" IF NOT EXISTS (SELECT * FROM ecsfc004_sinData WHERE cprj='{0}' and line='{2}') INSERT INTO ecsfc004_sinData (cprj,line,t_dsca) VALUES ('{0}','{2}', '{1}'); else update ecsfc004_sinData set t_dsca='{1}' where cprj='{0}' and line='{2}';", (string)n["t_cprj"], (string)n["t_dsca"], updatas["line"].ToString())); } cc1.connectionofc008_modify(upStr.ToString()); return(upStr.ToString()); }
public string Post([FromBody] object value) { //須注意來源格式的宣告要正確 //此處因來源為使用json 而此處定義為object(如此才能收到資料) int kd = 5682; var jd = JObject.Parse(value.ToString()); string wt = (string)jd["time"] ?? DateTime.Now.ToString(); DateTime dt = Convert.ToDateTime(wt); //var jData = (JObject)JsonConvert.DeserializeObject(value.ToString()); int ti = Convert.ToInt32((string)jd["status"]); string cprj = (string)jd["cprj"]; string line = (string)jd["line"]; string nopr = (string)jd["nopr"]; string empl = (string)jd["empl"]; //mode用以判斷是否為協作 //mode=1為協作專案 string mode = (string)jd["mode"]; int autmTotal = 0; switch (ti) { case 1: //未開 此處status數字代表意義與前端不同 //此處為欲變更為之狀態代號 this.cc1.connectionofc008_modify(@"insert into ecsfc933_mdt(cprj,line,nopr,sdate,sdtim,emno) values('" + cprj + "','" + line + "','" + nopr + "','" + dt.ToString("yyyy-MM-dd") + "','" + dt.ToString("HHmm") + "','" + empl + "')"); this.cc1.connectionofc008_modify(@"update ecsfc929_memb set sdate='" + dt.ToString("yyyy-MM-dd") + "',sdtim='" + dt.ToString("HHmm") + "',code='*',statuscode='1' where cprj='" + cprj + "'and line='" + line + "' and nopr='" + nopr + "'"); try { if (line.Trim() == "P722") { //Task.Run(() => cc1.RunCommandAsynchronously("update rp3440.baan.baan.tecsfc914230 set " + "t_adat_" + nopr + "='" + dt.ToString("yyyy-MM-dd") + "' where t_cprj='" + cprj + "' and t_line='" + line + "'")); cc1.connectionofc008_modify("update rp3440.baan.baan.tecsfc914230 set " + "t_adat_" + nopr + "='" + dt.ToString("yyyy-MM-dd") + "' where t_cprj='" + cprj + "' and t_line='" + line + "'"); } else if (nopr.Trim() == "1") { //Task.Run(() => cc1.RunCommandAsynchronously("update rp3440.baan.baan.tecsfc915230 set t_apdt='" + dt.ToString("yyyy-MM-dd") + "' where t_cprj='" + cprj + "' and t_line='" + line + "'")); cc1.connectionofc008_modify("update rp3440.baan.baan.tecsfc915230 set t_apdt='" + dt.ToString("yyyy-MM-dd") + "' where t_cprj='" + cprj + "' and t_line='" + line + "'"); } } catch (Exception ex) { smm.Mail_Send("*****@*****.**", "*****@*****.**", "ecsfc914、915更新失敗", "'" + cprj + "','" + nopr + "'更新失敗'" + ex.ToString() + "'!!!", true); } return("test return: " + kd + ":" + wt + "=>" + ti + ":" + cprj); case 2: //轉至休停 //autmTotal = autmCal(cprj, line, nopr); DateTime dk = Convert.ToDateTime(getLatestSdate(cprj, line, nopr)); if (dk <= dt) { if (mode == "1") { cc1.connectionofc008_modify(@"update ecsfc933_mdt set edate='" + dt.ToString("yyyy-MM-dd") + "',edtim='" + dt.ToString("HHmm") + "' where cprj='" + cprj + "' and line='" + line + "' and nopr='" + nopr + "' and msfid=(select top 1 msfid from ecsfc933_mdt where cprj='" + cprj + "' and line='" + line + "' and nopr='" + nopr + "' and cooperation='1' and emno='" + empl + "' order by msfid desc);" + "insert into ecsfc933_mdt (cprj,line,nopr,emno,cooperation) values('" + cprj + "','" + line + "','" + nopr + "','" + empl + "','1')" ); } else { cc1.connectionofc008_modify(@"update ecsfc933_mdt set edate='" + dt.ToString("yyyy-MM-dd") + "',edtim='" + dt.ToString("HHmm") + "' where cprj='" + cprj + "' and line='" + line + "' and nopr='" + nopr + "' and msfid=(select top 1 msfid from ecsfc933_mdt where cprj='" + cprj + "' and line='" + line + "' and nopr='" + nopr + "' order by msfid desc);" + "update ecsfc929_memb set statuscode='2',autm='" + autmCal(cprj, line, nopr) + "' where cprj='" + cprj + "' and line='" + line + "' and nopr='" + nopr + "'" ); } return("test return: " + kd + ":" + wt + "=>" + ti + ":" + cprj); } else { return("1"); } case 0: //轉至開始 if (mode == "1") { cc1.connectionofc008_modify("update ecsfc933_mdt set sdate='" + dt.ToString("yyyy-MM-dd") + "',sdtim='" + dt.ToString("HHmm") + "' where cprj='" + cprj + "' and line='" + line + "' and nopr='" + nopr + "' and msfid=(select top 1 msfid from ecsfc933_mdt where cprj='" + cprj + "' and line='" + line + "' and nopr='" + nopr + "' and cooperation='1' and emno='" + empl + "' order by msfid desc);" ); } else { cc1.connectionofc008_modify("update ecsfc933_mdt set sdate='" + dt.ToString("yyyy-MM-dd") + "',sdtim='" + dt.ToString("HHmm") + "' where cprj='" + cprj + "' and line='" + line + "' and nopr='" + nopr + "' and msfid=(select top 1 msfid from ecsfc933_mdt where cprj='" + cprj + "' and line='" + line + "' and nopr='" + nopr + "' order by msfid desc);" + "update ecsfc929_memb set statuscode='1',code='*' where cprj='" + cprj + "' and line='" + line + "' and nopr='" + nopr + "'" ); } return("test return: " + kd + ":" + wt + "=>" + ti + ":" + cprj); case 3: //紅異 return("test return: " + kd + ":" + wt + "=>" + ti + ":" + cprj); case 4: //黃異 return("test return: " + kd + ":" + wt + "=>" + ti + ":" + cprj); case 5: //待復工 尚未完成 if (mode == "1") { cc1.connectionofc008_modify("update ecsfc933_mdt set sdate='',sdtim='' where cprj='" + cprj + "' and line='" + line + "' and nopr='" + nopr + "' and msfid=(select top 1 msfid from ecsfc933_mdt where cprj='" + cprj + "' and line='" + line + "' and nopr='" + nopr + "' and cooperation='1' and emno='" + empl + "' order by msfid desc)"); } else { cc1.connectionofc008_modify("update ecsfc933_mdt set sdate='',sdtim='' where cprj='" + cprj + "' and line='" + line + "' and nopr='" + nopr + "' and msfid=(select top 1 msfid from ecsfc933_mdt where cprj='" + cprj + "' and line='" + line + "' and nopr='" + nopr + "' order by msfid desc)"); this.cc1.connectionofc008_modify(@"update ecsfc929_memb set code='*',statuscode='1' where cprj='" + cprj + "'and line='" + line + "' and nopr='" + nopr + "'"); } return("test return: " + kd + ":" + wt + "=>" + ti + ":" + cprj); case 7: //進行中完工 autm計算 if (Convert.ToDateTime(getLatestSdate(cprj, line, nopr)) <= dt) { if (mode == "1") { cc1.connectionofc008_modify(@"update ecsfc933_mdt set edate='" + dt.ToString("yyyy-MM-dd") + "',edtim='" + dt.ToString("HHmm") + "' where cprj='" + cprj + "' and line='" + line + "' and nopr='" + nopr + "' and msfid=(select top 1 msfid from ecsfc933_mdt where cprj='" + cprj + "' and line='" + line + "' and nopr='" + nopr + "' and cooperation='1' and emno='" + empl + "' order by msfid desc);" + "delete from ecsfc933_mdt where cprj='" + cprj + "' and line='" + line + "' and nopr='" + nopr + "' and (sdate is null and sdtim is null);" ); } else { autmTotal = autmCal(cprj, line, nopr); cc1.connectionofc008_modify("update ecsfc929_memb set edate='" + dt.ToString("yyyy-MM-dd") + "',edtim='" + dt.ToString("HHmm") + "',autm='" + autmTotal + "',pfc='是',statuscode='6' where cprj='" + cprj + "' and line='" + line + "' and nopr='" + nopr + "'"); } return("test return: " + kd + ":" + wt + "=>" + ti + ":" + cprj); } else { return("1"); } case 8: //休停中完工 DateTime glt = Convert.ToDateTime(getLatestSdate(cprj, line, nopr, 0)); if (Convert.ToDateTime(getLatestSdate(cprj, line, nopr, 0)) <= dt) { if (mode == "1") { cc1.connectionofc008_modify("delete from ecsfc933_mdt where cprj='" + cprj + "' and line='" + line + "' and nopr='" + nopr + "' and (sdate is null and sdtim is null)"); } else { string sdt = glt.ToString("yyyy-MM-dd") != DateTime.Now.ToString("yyyy-MM-dd") ? "750" : glt.ToString("HHmm"); cc1.connectionofc008_modify(@" update ecsfc933_mdt set sdate='" + DateTime.Now.ToString("yyyy-MM-dd") + "',sdtim='" + sdt + "',edate='',edtim='' where msfid=(select top 1 msfid from ecsfc933_mdt where cprj='" + cprj + "' and line='" + line + "' and nopr='" + nopr + "' order by msfid desc)" + "update ecsfc929_memb set edate='" + dt.ToString("yyyy-MM-dd") + "',edtim='" + dt.ToString("HHmm") + "',pfc='是',statuscode='6',msfid=(select top 1 msfid from ecsfc933_mdt where cprj='" + cprj + "' and line='" + line + "' and nopr='" + nopr + "' and (sdate is not null and edate is not null) order by msfid desc) where cprj='" + cprj + "' and line='" + line + "' and nopr='" + nopr + "';" + "delete from ecsfc933_mdt where cprj='" + cprj + "' and line='" + line + "' and nopr='" + nopr + "' and (sdate is null and sdtim is null)" ); } if (glt.ToString("yyyy-MM-dd") == DateTime.Now.ToString("yyyy-MM-dd")) { return(""); } else { return("test return: " + kd + ":" + wt + "=>" + ti + ":" + cprj); } } else { return("1"); } default: return("test return: " + kd + ":" + wt + "=>" + ti + ":" + cprj); } }
// PUT api/<controller>/5 public string Put(int id, [FromBody] string value) { var originalData = JObject.Parse(value.ToString()); //抓取所有originalData["machs"]下的key name var o2 = JObject.Parse(originalData["machs"].ToString()); IList <string> keys = o2.Properties().Select(p => p.Name).ToList(); string tstr = ""; Array d = keys.ToArray(); try { for (int di = 0; di < d.Length; di++)//機台單位 { int totalClean = 0; int totalChk = 0; int totalOil = 0; string i = keys[di]; //insert 機台主資料 string machID = (string)i; string machName = (string)o2[i]["imgName"]; string insertMain = string.Format("insert into ChkMachInfo(sno,mach_id,mach_name,mach_map)values('{0}','{1}','{2}','{3}');" , machID , machID , machName , machName); string insertCoords = "insert into ChkPointCoords(sno,coordsID,coords,SubImg) values"; StringBuilder typeCleanInStr = new StringBuilder("insert into ChkItem(sno,[6s_type],coordsID ,hand_order, part, standard ,method ,tool ,time , cycle, nextchk_date, sortNo) values "); StringBuilder typeChkInStr = new StringBuilder("insert into ChkItem(sno,[6s_type],coordsID ,hand_order, part, position, standard, method, process, time, cycle, nextchk_date, sortNo) values "); StringBuilder typeOilInStr = new StringBuilder("insert into ChkItem(sno,[6s_type],coordsID ,hand_order, position, standard, method, oil, tool, time, cycle, nextchk_date, sortNo) values "); StringBuilder insertChkList = new StringBuilder("insert into chkList(sno,hand_order,coordsID,chk_date) values"); //string insertChkItem = "insert into chkItem(sno,handorder,part,standard,['6s_type'],cycle,nextchk_date) values "; StringBuilder inCICombine = new StringBuilder(); int coordsCt = 0; tstr += o2[i]["imgName"]; //抓取所有originalData["machs"][mid]下的point key name IList <string> locas = JObject.Parse(o2[i]["chkData"].ToString()).Properties().Select(p => p.Name).ToList(); int t = 0; Array locasAry = locas.ToArray(); for (int locA = 0; locA < locasAry.Length; locA++)//點檢位置單位 { string locaObj = locas[locA]; string dot = ""; //insert coord datas string coordX = o2[i]["chkData"][locaObj]["coords"]["x"].ToString(); string coordY = o2[i]["chkData"][locaObj]["coords"]["y"].ToString(); dot = coordsCt != 0 ? "," : ""; insertCoords += dot + "('" + machID + "','" + locas[locA] + "','" + coordX + "," + coordY + "','" + o2[i]["chkData"][locaObj]["subImgName"]["s1"].ToString() + "')"; coordsCt++; //chkitem 各個欄位 //get items key name IList <string> items = JObject.Parse(o2[i]["chkData"][locaObj]["items"].ToString()).Properties().Select(p => p.Name).ToList(); var dkj = JObject.Parse(o2[i]["chkData"][locaObj]["items"].ToString()); string dot2 = ""; Array itemsAry = items.ToArray(); for (int iat = 0; iat < itemsAry.Length; iat++)//依點檢、給油、清掃資料格式區分 { StringBuilder insertChkItem = new StringBuilder(); IList <string> typeItems = JObject.Parse(o2[i]["chkData"][locaObj]["items"][items[iat]].ToString()).Properties().Select(p => p.Name).ToList(); Array typeItems_ary = typeItems.ToArray(); for (int tya = 0; tya < typeItems_ary.Length; tya++)//跑該分類之所有資料 { StringBuilder icol = new StringBuilder(); IList <string> ItemsCol = JObject.Parse(o2[i]["chkData"][locaObj]["items"][items[iat]][typeItems[tya]].ToString()).Properties().Select(p => p.Name).ToList(); Array icl = ItemsCol.ToArray(); icol.Append("'" + machID + "'," + "'" + items[iat] + "','" + locas[locA] + "'"); StringBuilder InChkD = new StringBuilder("('" + machID + "','" + o2[i]["chkData"][locaObj]["items"][items[iat]][typeItems[tya]]["hand_order"].ToString() + "','" + locas[locA] + "','" + o2[i]["chkData"][locaObj]["items"][items[iat]][typeItems[tya]]["nextchk_date"].ToString() + "'),"); insertChkList.Append(InChkD); for (int ict = 0; ict < icl.Length; ict++)//該資料列下的資料欄位(依分類不同所含欄位也相異) { //string iidf = ItemsCol.ToArray()[ict].ToString(); //string dot3 = ict != 0 ? "," : ""; string dot3 = ","; icol.Append(dot3 + "'" + o2[i]["chkData"][locaObj]["items"][items[iat]][typeItems[tya]][ItemsCol[ict]].ToString() + "'"); } string dot4 = tya != 0 ? "," : ""; insertChkItem.Append(dot4 + "(" + icol + ")"); } t++; switch (items[iat]) { case "clean": string dot5 = totalClean != 0 ? "," : ""; typeCleanInStr.Append(dot5 + insertChkItem);//此處insertChkItem為該點下對應分類所有行資料,此處動作為整併所有點chkPoint中對應分類的資料彙總。e.g. p0_clean+p1_clean... totalClean++; break; case "chk": string dot51 = totalChk != 0 ? "," : ""; typeChkInStr.Append(dot51 + insertChkItem); totalChk++; break; default: string dot52 = totalOil != 0 ? "," : ""; typeOilInStr.Append(dot52 + insertChkItem); totalOil++; break; } //inCICombine.Append(insertChkItem.Append(";")); } } inCICombine.Append(typeCleanInStr.ToString() + ";" + typeChkInStr.ToString() + ";" + typeOilInStr + ";"); insertCoords += ";"; insertChkList = insertChkList.Remove(insertChkList.Length - 1, 1).Append(";"); tstr = insertMain + insertCoords + inCICombine + insertChkList; //insert chkItems cc1.connectionofc008_modify(tstr); } return(tstr); } catch (Exception ex) { return(ex.ToString()); } }