public static int UAddUserInfo(SqlConnection con, SqlTransaction sqt, TUserInfo ui) { try { string sql = "insert into tUserInfo(UCode,UName,UPassword,UIdentityCardNo,UTel1,UTel2,UAddress,UEntryTime,UState)" + "values(@UCode,@UName,@UPassword,@UIdentityCardNo,@UTel1,@UTel2,@UAddress,GETDATE(),1)"; int iRtn = MsSqlHelper.ExecSqlUControl(con, sqt, sql, new SqlParameter("@UCode", ui.Ucode), new SqlParameter("@UName", ui.Uname), new SqlParameter("@UPassword", ui.Upassword), new SqlParameter("@UIdentityCardNo", ui.Uidentitycardno), new SqlParameter("@UTel1", ui.Utel1), new SqlParameter("@UTel2", ui.Utel2), new SqlParameter("@UAddress", ui.Uaddress) ); if (iRtn == 1) { string sQuery = "select max(UID) as UID from tUserInfo where UState = 1"; return(Convert.ToInt32(MsSqlHelper.GetSingle(con, sqt, sQuery))); } else { return(-1); } } catch (Exception e) { LogHelper.WriteLog("TUserInfoDAL.UAddUserInfo", e); throw e; } }
public static int AddTaskItem(SqlConnection con, SqlTransaction sqt, TTaskItem ti) { string sqlHead = String.Empty; int TaskItemId = 0; try { sqlHead = "insert into tTaskItem(TaskID,MID,BeginTime) values(@TaskID,@MID,@BeginTime)"; SqlParameter[] pms = new SqlParameter[] { new SqlParameter("@TaskID", ti.TaskID), new SqlParameter("@MID", ti.MID), new SqlParameter("@BeginTime", ti.BeginTime) }; if (MsSqlHelper.ExecSqlUControl(con, sqt, sqlHead, pms) == 1) { TaskItemId = Convert.ToInt32(MsSqlHelper.GetSingle(con, sqt, "select max(TaskItemID) as TaskItemID from tTaskItem where TaskID=@TaskID" , new SqlParameter("@TaskID", ti.TaskID))); foreach (TTaskItemWorkers tw in ti.ListWorks) { tw.TaskID = ti.TaskID; tw.TaskItemID = TaskItemId; TTaskItemWorkersDAL.AddTaskItemWorker(con, sqt, tw); } return(1); } else { return(0); } } catch (Exception e) { LogHelper.WriteLog("AddTaskItem" + "\r\n" + sqlHead, e); throw e; } }
public static int AddCarInfo(SqlConnection con, SqlTransaction sqr, ref TCarInfo ci) { String sql = String.Empty; try { sql = "Insert into tCarInfo(CarName,CarNumber,CarTrevalDistance,CarComeTime,CarOwner,CarOwnerTel1,CarOwnerTel2,OprtUserCode)" + "values(@CarName,@CarNumber,@CarTrevalDistance,@CarComeTime,@CarOwner,@CarOwnerTel1,@CarOwnerTel2,@OprtUserCode)"; Int32 CarID = 0; SqlParameter[] pms = new SqlParameter[] { new SqlParameter("@CarName",ci.CarName), new SqlParameter("@CarNumber",ci.CarNumber), new SqlParameter("@CarTrevalDistance",ci.CarTrevalDistance), new SqlParameter("@CarComeTime",ci.CarComeTime), new SqlParameter("@CarOwner",ci.CarOwner), new SqlParameter("@CarOwnerTel1",ci.CarOwnerTel1), new SqlParameter("@CarOwnerTel2",ci.CarOwnerTel2), new SqlParameter("@OprtUserCode",ci.OprtUserCode) }; if (MsSqlHelper.ExecSqlUControl(con, sqr, sql, pms) == 1) { CarID = Convert.ToInt32(MsSqlHelper.GetSingle(con, sqr, "select max(CarID) as CarID from tCarInfo where OprtUserCode=@OprtUserCode", new SqlParameter("@OprtUserCode", ci.OprtUserCode))); ci.CarID = CarID; return 1; } else { return 0; } } catch(Exception e) { LogHelper.WriteLog("AddCarInfo", e); return 0; } }
public static int AddTask(SqlConnection con, SqlTransaction sqt, ref TTaskInfo ti) { string sql = String.Empty; Int32 TaskID = 0; try { sql = "insert into tTaskHead(CarID,BeginDate,OprtUserCode) values (@CarID,@BeginDate,@OprtUserCode)"; SqlParameter[] pms = new SqlParameter[] { new SqlParameter("@CarID", ti.CarID), new SqlParameter("@BeginDate", ti.BeginDate), new SqlParameter("@OprtUserCode", ti.OprtUserCode) }; if (MsSqlHelper.ExecSqlUControl(con, sqt, sql, pms) == 1) { TaskID = Convert.ToInt32(MsSqlHelper.GetSingle(con, sqt, "select max(TaskID) as TaskID from tTaskHead where OprtUserCode=@OprtUserCode", new SqlParameter("@OprtUserCode", ti.OprtUserCode))); ti.TaskID = TaskID; foreach (var taskItem in ti.ListItems) { taskItem.TaskID = TaskID; TTaskItemDAL.AddTaskItem(con, sqt, taskItem); } return(1); } else { return(0); } } catch (Exception e) { LogHelper.WriteLog("TTaskInfoDAL.AddTask 1", e); throw e; } }