public static bool Insert(ObjectModule.Local.User gu)
{
try
{
string sql = @"insert into User_DB
(USER_ID,USER_NAME,PASSWORD,USER_GROUP,UPDATED_TIME,UPDATED_BY,DEPARTMENT,SHIFT,FINGER_TEMPLATE,FINGER_TEMPLATE_1)
VALUES
(@USER_ID,@USER_NAME,@PASSWORD,@USER_GROUP,@UPDATED_TIME,@UPDATED_BY,@DEPARTMENT,@SHIFT,@FINGER_TEMPLATE,@FINGER_TEMPLATE_1)";
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(sql);
cmd.Parameters.Add("@USER_NAME", System.Data.SqlDbType.VarChar).Value = gu.USER_NAME;
cmd.Parameters.Add("@PASSWORD", System.Data.SqlDbType.VarChar).Value = gu.PASSWORD;
cmd.Parameters.Add("@USER_GROUP", System.Data.SqlDbType.VarChar).Value = gu.USER_GROUP;
cmd.Parameters.Add("@UPDATED_TIME", System.Data.SqlDbType.DateTime).Value = System.DateTime.Now;
cmd.Parameters.Add("@UPDATED_BY", System.Data.SqlDbType.VarChar).Value = gu.UPDATED_BY;
cmd.Parameters.Add("@USER_ID", System.Data.SqlDbType.VarChar).Value = gu.USER_ID;
cmd.Parameters.Add("@DEPARTMENT", System.Data.SqlDbType.VarChar).Value = gu.DEPARTMENT;
cmd.Parameters.Add("@SHIFT", System.Data.SqlDbType.VarChar).Value = gu.SHIFT;
cmd.Parameters.Add("@FINGER_TEMPLATE", System.Data.SqlDbType.VarChar).Value = gu.FINGER_TEMPLATE;
cmd.Parameters.Add("@FINGER_TEMPLATE_1", System.Data.SqlDbType.VarChar).Value = gu.FINGER_TEMPLATE_1;
return(Common.DB.SqlDB.SetData(cmd, StaticRes.Local));
}
catch (SqlException ee)
{
throw ee;
}
}
public static ObjectModule.Local.User Validate_User(string User_ID)
{
if (User_ID.Length == 0)
{
throw new System.Exception("Please input your user ID first !!");
}
DataTable dt = DataProvider.Local.User.Select(User_ID);
if (dt.Rows.Count == 0)
{
throw new System.Exception("Invaild User !!");
}
ObjectModule.Local.User lu = new ObjectModule.Local.User(dt.Rows[0]);
return(lu);
}
public static bool Update(ObjectModule.Local.User gu)
{
try
{
string sql = @"Update User_DB set USER_NAME=@USER_NAME,PASSWORD=@PASSWORD,USER_GROUP=@USER_GROUP,SHIFT=@SHIFT,
UPDATED_TIME =@UPDATED_TIME,UPDATED_BY=@UPDATED_BY,FINGER_TEMPLATE=@FINGER_TEMPLATE,FINGER_TEMPLATE_1=@FINGER_TEMPLATE_1 where USER_ID=@USER_ID and DEPARTMENT=@DEPARTMENT ";
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(sql);
cmd.Parameters.Add("@USER_NAME", System.Data.SqlDbType.VarChar).Value = gu.USER_NAME;
cmd.Parameters.Add("@PASSWORD", System.Data.SqlDbType.VarChar).Value = gu.PASSWORD;
cmd.Parameters.Add("@USER_GROUP", System.Data.SqlDbType.VarChar).Value = gu.USER_GROUP;
cmd.Parameters.Add("@UPDATED_TIME", System.Data.SqlDbType.DateTime).Value = System.DateTime.Now;
cmd.Parameters.Add("@UPDATED_BY", System.Data.SqlDbType.VarChar).Value = gu.UPDATED_BY;
cmd.Parameters.Add("@USER_ID", System.Data.SqlDbType.VarChar).Value = gu.USER_ID;
cmd.Parameters.Add("@DEPARTMENT", System.Data.SqlDbType.VarChar).Value = gu.DEPARTMENT;
cmd.Parameters.Add("@SHIFT", System.Data.SqlDbType.VarChar).Value = gu.SHIFT;
cmd.Parameters.Add("@FINGER_TEMPLATE", System.Data.SqlDbType.VarChar).Value = gu.FINGER_TEMPLATE;
cmd.Parameters.Add("@FINGER_TEMPLATE_1", System.Data.SqlDbType.VarChar).Value = gu.FINGER_TEMPLATE_1;
return(Common.DB.SqlDB.SetData(cmd, StaticRes.Local));
}
catch (SqlException ee)
{
throw ee;
}
}
public static bool User_Insert(ObjectModule.Local.User gu)
{
if (gu.DEPARTMENT.Length == 0)
{
throw new System.Exception("Please select department !!");
}
if (gu.PASSWORD.Length == 0)
{
throw new System.Exception("Please input password !!");
}
if (gu.USER_GROUP.Length == 0)
{
throw new System.Exception("Please input user group !!");
}
if (gu.USER_ID.Length == 0)
{
throw new System.Exception("Please input user ID !!");
}
if (gu.USER_NAME.Length == 0)
{
throw new System.Exception("Please input user name !!");
}
return(DataProvider.Local.User.Insert(gu));
}
public static bool User_Update(ObjectModule.Local.User gu)
{
return(DataProvider.Local.User.Update(gu));
}
public static bool User_Insert(ObjectModule.Local.User gu)
{
return(DataProvider.Local.User.Insert(gu));
}
