| | |
| | | //反序列化 |
| | | msg2 = "[" + msg2.ToString() + "]"; |
| | | List<WorkDay> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<WorkDay>>(msg2); |
| | | |
| | | long HItemID = list[0].HItemID; |
| | | |
| | | //保存 |
| | | //保存完毕后处理 |
| | | if (HItemID == 0) |
| | | { |
| | | oCN.BeginTran(); |
| | | string sql = string.Format(@"insert into Gy_WorkDay (HDate,HWorkBegin,HWorkEnd,HNoonbreakBegin,HNoonbreakEnd,HNightbreakBegin,HNightbreakEnd) |
| | | values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}')", list[0].HDate, list[0].HWorkBegin, list[0].HWorkEnd, list[0].HNoonbreakBegin, list[0].HNoonbreakEnd, list[0].HNightbreakBegin, list[0].HNightbreakEnd); |
| | | string sql = string.Format(@"insert into Gy_WorkDay (HDate,HWorkBegin,HWorkEnd,HNoonbreakBegin,HNoonbreakEnd,HNightbreakBegin,HNightbreakEnd,HNoonbreakBegin2,HNoonbreakEnd2,HNightbreakBegin2,HNightbreakEnd2) |
| | | values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}')", list[0].HDate, list[0].HWorkBegin, list[0].HWorkEnd, list[0].HNoonbreakBegin, list[0].HNoonbreakEnd, list[0].HNightbreakBegin, list[0].HNightbreakEnd, list[0].HNoonbreakBegin2, list[0].HNoonbreakEnd2, list[0].HNightbreakBegin2, list[0].HNightbreakEnd2); |
| | | oCN.RunProc(sql); |
| | | oCN.Commit(); |
| | | } |
| | |
| | | ",HWorkBegin='" + list[0].HWorkBegin + "'" + |
| | | ",HWorkEnd='" + list[0].HWorkEnd + "'" + |
| | | ",HNoonbreakBegin='" + list[0].HNoonbreakBegin + "'" + |
| | | ",HNoonbreakEnd=" + list[0].HNoonbreakEnd + |
| | | ",HNightbreakBegin=" + list[0].HNightbreakBegin + |
| | | ",HNightbreakEnd=" + list[0].HNightbreakEnd + |
| | | ",HNoonbreakEnd='" + list[0].HNoonbreakEnd + "'" + |
| | | ",HNightbreakBegin='" + list[0].HNightbreakBegin + "'" + |
| | | ",HNightbreakEnd='" + list[0].HNightbreakEnd + "'" + |
| | | ",HNoonbreakBegin2='" + list[0].HNoonbreakBegin2 + "'" + |
| | | ",HNoonbreakEnd2='" + list[0].HNoonbreakEnd2 + "'" + |
| | | ",HNightbreakBegin2='" + list[0].HNightbreakBegin2 + "'" + |
| | | ",HNightbreakEnd2='" + list[0].HNightbreakEnd2 + "'" + |
| | | " Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | // |
| | | oCN.Commit(); |