| | |
| | | { |
| | | foreach (DataGridViewRow item in grdMain.Rows) |
| | | { |
| | | if (item.Cells[2] == null|| item.Cells[2].Value == null) |
| | | if (item.Cells[2] == null|| item.Cells[2].Value == null || item.Cells[6] == null || item.Cells[6].Value == null) |
| | | { |
| | | if(DBUtility.ClsPub.isLong(item.Cells[2].Value)!=0 && DBUtility.ClsPub.isLong(item.Cells[6].Value) == 0) |
| | | { |
| | | MessageBox.Show("没æç»´æ¤çç»ï¼"); |
| | | } |
| | | //MessageBox.Show("") |
| | | continue; |
| | | } |
| | | var remark = item.Cells[5].EditedFormattedValue==null?"":item.Cells[5].EditedFormattedValue.ToString(); |
| | |
| | | if (item.Cells[9].Value.ToString().Trim() == "") |
| | | { |
| | | item.Cells[9].Value = "23:00:00"; |
| | | } |
| | | } |
| | | var sql = "insert into Gy_GroupEmpListSub(HInterID,HEmpID,HGroupID,HBeginTimes,HEndTimes,HRemark) values (" + hinterId + "," + item.Cells[2].Value + "," + item.Cells[6].Value + ",'" + item.Cells[8].Value + "','" + item.Cells[9].Value + "','" + remark + "')"; |
| | | oWeb.getRunProc(sql, ref Pub_Class.ClsPub.sExeReturnInfo); |
| | | } |