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;
}
}
