private void btnSelect_Click(object sender, EventArgs e)
{
if (dgvStaffs.SelectedRows.Count == 0)
{
return;
}
List <DataGridViewRow> dgvrs = new List <DataGridViewRow>();
foreach (DataGridViewRow item in dgvStaffs.SelectedRows)
{
Maticsoft.Model.SMT_STAFF_INFO info = (Maticsoft.Model.SMT_STAFF_INFO)item.Tag;
if (_selectMaxDate == null)
{
_selectMaxDate = info.VALID_ENDTIME;
}
else
{
if (_selectMaxDate < info.VALID_ENDTIME)
{
_selectMaxDate = info.VALID_ENDTIME;
}
}
dgvrs.Add(item);
}
if (_selectMaxDate != null)
{
dtpEnd.Value = (DateTime)_selectMaxDate;
}
foreach (var item in dgvrs)
{
dgvStaffs.Rows.Remove(item);
}
dgvSelected.Rows.AddRange(dgvrs.ToArray());
}
public FrmPrivateCopy(Maticsoft.Model.SMT_STAFF_INFO staffInfo, List <Maticsoft.Model.SMT_STAFF_DOOR> doors)
{
InitializeComponent();
_staffInfo = staffInfo;
_staffDoors = doors;
this.Text = "当前被复制权限人员：" + _staffInfo.REAL_NAME;
}
private void DoShowInfos(List <Maticsoft.Model.SMT_STAFF_INFO> staffInfos)
{
dgvStaffs.Rows.Clear();
foreach (var item in staffInfos)
{
bool find = false;
foreach (DataGridViewRow select in dgvSelected.Rows)//判断是否已选择
{
Maticsoft.Model.SMT_STAFF_INFO s = (Maticsoft.Model.SMT_STAFF_INFO)select.Tag;
if (s.ID == item.ID)
{
find = true;
break;
}
}
if (find)
{
continue;
}
DataGridViewRow row = new DataGridViewRow();
row.CreateCells(dgvStaffs,
item.STAFF_NO,
item.REAL_NAME,
item.ORG_NAME + "[" + item.ORG_CODE + "]",
item.VALID_ENDTIME.ToString("yyyy-MM-dd")
);
row.Tag = item;
dgvStaffs.Rows.Add(row);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.SMT_STAFF_INFO DataRowToSimpleModel(DataRow row)
{
Maticsoft.Model.SMT_STAFF_INFO model = new Maticsoft.Model.SMT_STAFF_INFO();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = decimal.Parse(row["ID"].ToString());
}
if (row["ORG_ID"] != null && row["ORG_ID"].ToString() != "")
{
model.ORG_ID = decimal.Parse(row["ORG_ID"].ToString());
}
if (row["STAFF_NO"] != null)
{
model.STAFF_NO = row["STAFF_NO"].ToString();
}
if (row["REAL_NAME"] != null)
{
model.REAL_NAME = row["REAL_NAME"].ToString();
}
if (row["VALID_STARTTIME"] != null && row["VALID_STARTTIME"].ToString() != "")
{
model.VALID_STARTTIME = DateTime.Parse(row["VALID_STARTTIME"].ToString());
}
if (row["VALID_ENDTIME"] != null && row["VALID_ENDTIME"].ToString() != "")
{
model.VALID_ENDTIME = DateTime.Parse(row["VALID_ENDTIME"].ToString());
}
if (row["IS_FORBIDDEN"] != null && row["IS_FORBIDDEN"].ToString() != "")
{
if ((row["IS_FORBIDDEN"].ToString() == "1") || (row["IS_FORBIDDEN"].ToString().ToLower() == "true"))
{
model.IS_FORBIDDEN = true;
}
else
{
model.IS_FORBIDDEN = false;
}
}
if (row["IS_DELETE"] != null && row["IS_DELETE"].ToString() != "")
{
if ((row["IS_DELETE"].ToString() == "1") || (row["IS_DELETE"].ToString().ToLower() == "true"))
{
model.IS_DELETE = true;
}
else
{
model.IS_DELETE = false;
}
}
if (row["STAFF_TYPE"] != null)
{
model.STAFF_TYPE = row["STAFF_TYPE"].ToString();
}
}
return(model);
}
public FrmAddOrModifyStaffPrivate(Maticsoft.Model.SMT_STAFF_INFO staffInfo)
{
InitializeComponent();
doorTree.LoadEnded += doorTree_LoadEnded;
this.staffInfo = staffInfo;
this.dtpStart.Value = this.staffInfo.VALID_STARTTIME;
this.dtpEnd.Value = this.staffInfo.VALID_ENDTIME;
this.Text = "当前授权对象：" + staffInfo.REAL_NAME;
}
private void ShowStaffInfo(DataGridViewRow row, object[] infos)
{
if (infos == null)
{
return;
}
try
{
if (picBox.Image != null)
{
picBox.Image.Dispose();
picBox.Image = null;
}
Maticsoft.Model.SMT_STAFF_INFO sinfo = infos[0] as Maticsoft.Model.SMT_STAFF_INFO;
ControllerState state = infos[1] as ControllerState;
if (sinfo.PHOTO != null && sinfo.PHOTO.Length > 0)
{
MemoryStream ms = new MemoryStream(sinfo.PHOTO);
Image bitmap = Image.FromStream(ms);
picBox.Image = bitmap;
}
if (sinfo != null)
{
lbStaffName.Text = sinfo.REAL_NAME;
lbDeptName.Text = sinfo.ORG_NAME;
}
else
{
lbStaffName.Text = "----";
lbDeptName.Text = "----";
}
if (state != null)
{
lbTime.Text = state.recordTime.ToString("yyyy-MM-dd HH:mm:ss ddd");
if (row.Cells[1].Value != null)
{
lbDoorName.Text = (string)row.Cells[1].Value;
}
else
{
lbDoorName.Text = "----";
}
lbAction.Text = AccessHelper.GetRecordReasonString(state.reasonNo).Replace(":", "\r\n");
}
else
{
lbTime.Text = ((DateTime)row.Cells[0].Value).ToString("yyyy-MM-dd HH:mm:ss ddd");
lbDoorName.Text = "----";
lbAction.Text = "----";
}
}
catch (Exception ex)
{
log.Error("显示信息异常：", ex);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.SMT_STAFF_INFO GetModel(decimal ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,ORG_ID,STAFF_NO_TEMPLET,STAFF_NO,REAL_NAME,SEX,JOB,BIRTHDAY,POLITICS,MARRIED,SKIIL_LEVEL,CER_NAME,CER_NO,TELE_PHONE,CELL_PHONE,NATIVE,NATION,RELIGION,EDUCATIONAL,EMAIL,VALID_STARTTIME,VALID_ENDTIME,ENTRY_TIME,ABORT_TIME,ADDRESS,PHOTO,CER_PHOTO_FRONT,CER_PHOTO_BACK,PRINT_TEMPLET_ID,IS_FORBIDDEN,IS_DELETE,REG_TIME,DEL_TIME,FORBIDDEN_TIME,ENABLE_TIME,MODIFY_TIME,STAFF_TYPE from SMT_STAFF_INFO ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Decimal)
};
parameters[0].Value = ID;
Maticsoft.Model.SMT_STAFF_INFO model = new Maticsoft.Model.SMT_STAFF_INFO();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
private void AddWatchData(Controller ctrlr, bool connected, ControllerState state, bool doorstate, bool relaystate)
{
string cardNo = null;
if (state != null)
{
if (_cards == null)
{
Maticsoft.BLL.SMT_CARD_INFO cardBll = new Maticsoft.BLL.SMT_CARD_INFO();
_cards = cardBll.GetModelList("");
}
cardNo = state.cardOrNoNumber;
var card = _cards.Find(m => m.CARD_WG_NO == state.cardOrNoNumber);
if (card != null)
{
cardNo = card.CARD_NO;
}
else
{
Maticsoft.BLL.SMT_CARD_INFO cardBll = new Maticsoft.BLL.SMT_CARD_INFO();
var c = cardBll.GetModelList("CARD_WG_NO='" + state.cardOrNoNumber + "'");
if (c.Count > 0)
{
_cards.Add(c[0]);
cardNo = c[0].CARD_NO;
}
}
}
string staffname = "未知";
string orgname = "未知";
Maticsoft.Model.SMT_STAFF_INFO sinfo = null;
if (cardNo != null)
{
try
{
Maticsoft.BLL.SMT_STAFF_INFO siBll = new Maticsoft.BLL.SMT_STAFF_INFO();
var ds = siBll.GetListByCardNum(cardNo);
var list = siBll.DataTableToListWithDept(ds.Tables[0]);
if (list.Count > 0)
{
staffname = list[0].REAL_NAME;
orgname = list[0].ORG_NAME;
sinfo = list[0];
}
}
catch (Exception ex)
{
log.Error("读取职员异常：", ex);
}
}
this.Invoke(new Action(() =>
{
foreach (MapCtrl item in _detectedMaps)
{
List <Maticsoft.Model.SMT_DOOR_INFO> doors;
List <Maticsoft.Model.SMT_FACERECG_DEVICE> faces;
GetDoors(item, out doors, out faces);
foreach (var door in doors)
{
if ((decimal)door.CTRL_ID != ctrlr.id)
{
continue;
}
var doorRect = item.GetDoor(door.ID, 1);
if (doorRect == null)
{
continue;
}
doorRect.IsOnline = connected;
int doorIndex = (int)door.CTRL_DOOR_INDEX;
bool doorLock = false;
if (state != null)
{
//更新状态
switch (doorIndex)
{
case 1:
doorLock = state.isOpenDoorOfLock1;
break;
case 2:
doorLock = state.isOpenDoorOfLock2;
break;
case 3:
doorLock = state.isOpenDoorOfLock3;
break;
case 4:
doorLock = state.isOpenDoorOfLock4;
break;
default:
break;
}
//更新状态
doorRect.IsOpen = doorLock;
door.OPEN_STATE = doorLock ? 1 : 0;
DoorDataHelper.UpdateDoorSync(door);
}
if ((!connected || state == null) && !doorstate)
{
door.OPEN_STATE = 2;
doorRect.IsOnline = false;
DoorDataHelper.UpdateDoorSync(door);
//item.ImageIndex = connected ? 0 : 2;
/*DataGridViewRow row = new DataGridViewRow();
* row.Tag = ctrlr;
* row.CreateCells(dgvRealLog, DateTime.Now, door.DOOR_NAME, string.Format("控制器：IP={0},SN={1} {2}！", ctrlr.ip, ctrlr.sn, connected ? "连接成功" : "无法连接"));
* row.DefaultCellStyle.BackColor = Color.Yellow;
* dgvRealLog.Rows.Insert(0, row);*/
}
else if ((byte)door.CTRL_DOOR_INDEX == state.doorNum)
{
DataGridViewRow row = new DataGridViewRow();
row.Tag = state;
if (!relaystate)
{
string actionname = AccessHelper.GetRecordReasonString(state.reasonNo);
if (!doorLock)
{
actionname += "，锁状态：关";
}
else
{
actionname += "，锁状态：开";
}
if (doorstate)
{
row.CreateCells(dgvRealLog, state.recordTime, door.DOOR_NAME + (state.isEnterDoor ? "-进门" : "-出门"), string.Format("人员:{0}，部门:{1},门禁:{2},卡号：{3},动作：{4}", staffname, orgname, door.DOOR_NAME, cardNo, actionname));
dgvRealLog.Rows.Insert(0, row);
row.Tag = new object[] { sinfo, state };
ShowStaffInfo(row, row.Tag as object[]);
while (dgvRealLog.Rows.Count > 2000)
{
dgvRealLog.Rows.RemoveAt(dgvRealLog.Rows.Count - 1);
}
}
}
}
}
item.Invalidate();
}
}));
}
public Maticsoft.Model.SMT_STAFF_INFO DataRowToModelByParOrgId(DataRow row)
{
Maticsoft.Model.SMT_STAFF_INFO model = new Maticsoft.Model.SMT_STAFF_INFO();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = decimal.Parse(row["ID"].ToString());
}
if (row["ORG_ID"] != null && row["ORG_ID"].ToString() != "")
{
model.ORG_ID = decimal.Parse(row["ORG_ID"].ToString());
}
if (row["STAFF_NO_TEMPLET"] != null && row["STAFF_NO_TEMPLET"].ToString() != "")
{
model.STAFF_NO_TEMPLET = decimal.Parse(row["STAFF_NO_TEMPLET"].ToString());
}
if (row["STAFF_NO"] != null)
{
model.STAFF_NO = row["STAFF_NO"].ToString();
}
if (row["REAL_NAME"] != null)
{
model.REAL_NAME = row["REAL_NAME"].ToString();
}
if (row["SEX"] != null && row["SEX"].ToString() != "")
{
model.SEX = int.Parse(row["SEX"].ToString());
}
if (row["JOB"] != null)
{
model.JOB = row["JOB"].ToString();
}
if (row["BIRTHDAY"] != null && row["BIRTHDAY"].ToString() != "")
{
model.BIRTHDAY = DateTime.Parse(row["BIRTHDAY"].ToString());
}
if (row["POLITICS"] != null)
{
model.POLITICS = row["POLITICS"].ToString();
}
if (row["MARRIED"] != null && row["MARRIED"].ToString() != "")
{
model.MARRIED = int.Parse(row["MARRIED"].ToString());
}
if (row["SKIIL_LEVEL"] != null)
{
model.SKIIL_LEVEL = row["SKIIL_LEVEL"].ToString();
}
if (row["CER_NAME"] != null)
{
model.CER_NAME = row["CER_NAME"].ToString();
}
if (row["CER_NO"] != null)
{
model.CER_NO = row["CER_NO"].ToString();
}
if (row["TELE_PHONE"] != null)
{
model.TELE_PHONE = row["TELE_PHONE"].ToString();
}
if (row["CELL_PHONE"] != null)
{
model.CELL_PHONE = row["CELL_PHONE"].ToString();
}
if (row["NATIVE"] != null)
{
model.NATIVE = row["NATIVE"].ToString();
}
if (row["NATION"] != null)
{
model.NATION = row["NATION"].ToString();
}
if (row["RELIGION"] != null)
{
model.RELIGION = row["RELIGION"].ToString();
}
if (row["EDUCATIONAL"] != null)
{
model.EDUCATIONAL = row["EDUCATIONAL"].ToString();
}
if (row["EMAIL"] != null)
{
model.EMAIL = row["EMAIL"].ToString();
}
if (row["VALID_STARTTIME"] != null && row["VALID_STARTTIME"].ToString() != "")
{
model.VALID_STARTTIME = DateTime.Parse(row["VALID_STARTTIME"].ToString());
}
if (row["VALID_ENDTIME"] != null && row["VALID_ENDTIME"].ToString() != "")
{
model.VALID_ENDTIME = DateTime.Parse(row["VALID_ENDTIME"].ToString());
}
if (row["ENTRY_TIME"] != null && row["ENTRY_TIME"].ToString() != "")
{
model.ENTRY_TIME = DateTime.Parse(row["ENTRY_TIME"].ToString());
}
if (row["ABORT_TIME"] != null && row["ABORT_TIME"].ToString() != "")
{
model.ABORT_TIME = DateTime.Parse(row["ABORT_TIME"].ToString());
}
if (row["ADDRESS"] != null)
{
model.ADDRESS = row["ADDRESS"].ToString();
}
// if (row["PHOTO"] != null && row["PHOTO"].ToString() != "")
// {
// model.PHOTO = (byte[])row["PHOTO"];
// }
if (row["CER_PHOTO_FRONT"] != null && row["CER_PHOTO_FRONT"].ToString() != "")
{
model.CER_PHOTO_FRONT = (byte[])row["CER_PHOTO_FRONT"];
}
if (row["CER_PHOTO_BACK"] != null && row["CER_PHOTO_BACK"].ToString() != "")
{
model.CER_PHOTO_BACK = (byte[])row["CER_PHOTO_BACK"];
}
if (row["PRINT_TEMPLET_ID"] != null && row["PRINT_TEMPLET_ID"].ToString() != "")
{
model.PRINT_TEMPLET_ID = decimal.Parse(row["PRINT_TEMPLET_ID"].ToString());
}
if (row["IS_FORBIDDEN"] != null && row["IS_FORBIDDEN"].ToString() != "")
{
if ((row["IS_FORBIDDEN"].ToString() == "1") || (row["IS_FORBIDDEN"].ToString().ToLower() == "true"))
{
model.IS_FORBIDDEN = true;
}
else
{
model.IS_FORBIDDEN = false;
}
}
if (row["IS_DELETE"] != null && row["IS_DELETE"].ToString() != "")
{
if ((row["IS_DELETE"].ToString() == "1") || (row["IS_DELETE"].ToString().ToLower() == "true"))
{
model.IS_DELETE = true;
}
else
{
model.IS_DELETE = false;
}
}
if (row["REG_TIME"] != null && row["REG_TIME"].ToString() != "")
{
model.REG_TIME = DateTime.Parse(row["REG_TIME"].ToString());
}
if (row["DEL_TIME"] != null && row["DEL_TIME"].ToString() != "")
{
model.DEL_TIME = DateTime.Parse(row["DEL_TIME"].ToString());
}
if (row["FORBIDDEN_TIME"] != null && row["FORBIDDEN_TIME"].ToString() != "")
{
model.FORBIDDEN_TIME = DateTime.Parse(row["FORBIDDEN_TIME"].ToString());
}
if (row["ENABLE_TIME"] != null && row["ENABLE_TIME"].ToString() != "")
{
model.ENABLE_TIME = DateTime.Parse(row["ENABLE_TIME"].ToString());
}
if (row["MODIFY_TIME"] != null && row["MODIFY_TIME"].ToString() != "")
{
model.MODIFY_TIME = DateTime.Parse(row["MODIFY_TIME"].ToString());
}
if (row["STAFF_TYPE"] != null)
{
model.STAFF_TYPE = row["STAFF_TYPE"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public decimal Add(Maticsoft.Model.SMT_STAFF_INFO model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SMT_STAFF_INFO(");
strSql.Append("ORG_ID,STAFF_NO_TEMPLET,STAFF_NO,REAL_NAME,SEX,JOB,BIRTHDAY,POLITICS,MARRIED,SKIIL_LEVEL,CER_NAME,CER_NO,TELE_PHONE,CELL_PHONE,NATIVE,NATION,RELIGION,EDUCATIONAL,EMAIL,VALID_STARTTIME,VALID_ENDTIME,ENTRY_TIME,ABORT_TIME,ADDRESS,PHOTO,CER_PHOTO_FRONT,CER_PHOTO_BACK,PRINT_TEMPLET_ID,IS_FORBIDDEN,IS_DELETE,REG_TIME,DEL_TIME,FORBIDDEN_TIME,ENABLE_TIME,MODIFY_TIME,STAFF_TYPE)");
strSql.Append(" values (");
strSql.Append("@ORG_ID,@STAFF_NO_TEMPLET,@STAFF_NO,@REAL_NAME,@SEX,@JOB,@BIRTHDAY,@POLITICS,@MARRIED,@SKIIL_LEVEL,@CER_NAME,@CER_NO,@TELE_PHONE,@CELL_PHONE,@NATIVE,@NATION,@RELIGION,@EDUCATIONAL,@EMAIL,@VALID_STARTTIME,@VALID_ENDTIME,@ENTRY_TIME,@ABORT_TIME,@ADDRESS,@PHOTO,@CER_PHOTO_FRONT,@CER_PHOTO_BACK,@PRINT_TEMPLET_ID,@IS_FORBIDDEN,@IS_DELETE,@REG_TIME,@DEL_TIME,@FORBIDDEN_TIME,@ENABLE_TIME,@MODIFY_TIME,@STAFF_TYPE)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@ORG_ID", SqlDbType.Decimal, 9),
new SqlParameter("@STAFF_NO_TEMPLET", SqlDbType.Decimal, 9),
new SqlParameter("@STAFF_NO", SqlDbType.NVarChar, 400),
new SqlParameter("@REAL_NAME", SqlDbType.NVarChar, 100),
new SqlParameter("@SEX", SqlDbType.TinyInt, 1),
new SqlParameter("@JOB", SqlDbType.NVarChar, 200),
new SqlParameter("@BIRTHDAY", SqlDbType.Date, 3),
new SqlParameter("@POLITICS", SqlDbType.NVarChar, 100),
new SqlParameter("@MARRIED", SqlDbType.TinyInt, 1),
new SqlParameter("@SKIIL_LEVEL", SqlDbType.NVarChar, 100),
new SqlParameter("@CER_NAME", SqlDbType.NVarChar, 100),
new SqlParameter("@CER_NO", SqlDbType.NVarChar, 400),
new SqlParameter("@TELE_PHONE", SqlDbType.NVarChar, 100),
new SqlParameter("@CELL_PHONE", SqlDbType.NVarChar, 100),
new SqlParameter("@NATIVE", SqlDbType.NVarChar, 400),
new SqlParameter("@NATION", SqlDbType.NVarChar, 100),
new SqlParameter("@RELIGION", SqlDbType.NVarChar, 100),
new SqlParameter("@EDUCATIONAL", SqlDbType.NVarChar, 100),
new SqlParameter("@EMAIL", SqlDbType.NVarChar, 100),
new SqlParameter("@VALID_STARTTIME", SqlDbType.DateTime),
new SqlParameter("@VALID_ENDTIME", SqlDbType.DateTime),
new SqlParameter("@ENTRY_TIME", SqlDbType.Date, 3),
new SqlParameter("@ABORT_TIME", SqlDbType.Date, 3),
new SqlParameter("@ADDRESS", SqlDbType.NVarChar, 400),
new SqlParameter("@PHOTO", SqlDbType.Image),
new SqlParameter("@CER_PHOTO_FRONT", SqlDbType.Image),
new SqlParameter("@CER_PHOTO_BACK", SqlDbType.Image),
new SqlParameter("@PRINT_TEMPLET_ID", SqlDbType.Decimal, 9),
new SqlParameter("@IS_FORBIDDEN", SqlDbType.Bit, 1),
new SqlParameter("@IS_DELETE", SqlDbType.Bit, 1),
new SqlParameter("@REG_TIME", SqlDbType.DateTime),
new SqlParameter("@DEL_TIME", SqlDbType.DateTime),
new SqlParameter("@FORBIDDEN_TIME", SqlDbType.DateTime),
new SqlParameter("@ENABLE_TIME", SqlDbType.DateTime),
new SqlParameter("@MODIFY_TIME", SqlDbType.DateTime),
new SqlParameter("@STAFF_TYPE", SqlDbType.VarChar, 20)
};
parameters[0].Value = model.ORG_ID;
parameters[1].Value = model.STAFF_NO_TEMPLET;
parameters[2].Value = model.STAFF_NO;
parameters[3].Value = model.REAL_NAME;
parameters[4].Value = model.SEX;
parameters[5].Value = model.JOB;
parameters[6].Value = model.BIRTHDAY;
parameters[7].Value = model.POLITICS;
parameters[8].Value = model.MARRIED;
parameters[9].Value = model.SKIIL_LEVEL;
parameters[10].Value = model.CER_NAME;
parameters[11].Value = model.CER_NO;
parameters[12].Value = model.TELE_PHONE;
parameters[13].Value = model.CELL_PHONE;
parameters[14].Value = model.NATIVE;
parameters[15].Value = model.NATION;
parameters[16].Value = model.RELIGION;
parameters[17].Value = model.EDUCATIONAL;
parameters[18].Value = model.EMAIL;
parameters[19].Value = model.VALID_STARTTIME;
parameters[20].Value = model.VALID_ENDTIME;
parameters[21].Value = model.ENTRY_TIME;
parameters[22].Value = model.ABORT_TIME;
parameters[23].Value = model.ADDRESS;
parameters[24].Value = model.PHOTO;
parameters[25].Value = model.CER_PHOTO_FRONT;
parameters[26].Value = model.CER_PHOTO_BACK;
parameters[27].Value = model.PRINT_TEMPLET_ID;
parameters[28].Value = model.IS_FORBIDDEN;
parameters[29].Value = model.IS_DELETE;
parameters[30].Value = model.REG_TIME;
parameters[31].Value = model.DEL_TIME;
parameters[32].Value = model.FORBIDDEN_TIME;
parameters[33].Value = model.ENABLE_TIME;
parameters[34].Value = model.MODIFY_TIME;
parameters[35].Value = model.STAFF_TYPE;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToDecimal(obj));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.SMT_STAFF_INFO model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update SMT_STAFF_INFO set ");
strSql.Append("ORG_ID=@ORG_ID,");
strSql.Append("STAFF_NO_TEMPLET=@STAFF_NO_TEMPLET,");
strSql.Append("STAFF_NO=@STAFF_NO,");
strSql.Append("REAL_NAME=@REAL_NAME,");
strSql.Append("SEX=@SEX,");
strSql.Append("JOB=@JOB,");
strSql.Append("BIRTHDAY=@BIRTHDAY,");
strSql.Append("POLITICS=@POLITICS,");
strSql.Append("MARRIED=@MARRIED,");
strSql.Append("SKIIL_LEVEL=@SKIIL_LEVEL,");
strSql.Append("CER_NAME=@CER_NAME,");
strSql.Append("CER_NO=@CER_NO,");
strSql.Append("TELE_PHONE=@TELE_PHONE,");
strSql.Append("CELL_PHONE=@CELL_PHONE,");
strSql.Append("NATIVE=@NATIVE,");
strSql.Append("NATION=@NATION,");
strSql.Append("RELIGION=@RELIGION,");
strSql.Append("EDUCATIONAL=@EDUCATIONAL,");
strSql.Append("EMAIL=@EMAIL,");
strSql.Append("VALID_STARTTIME=@VALID_STARTTIME,");
strSql.Append("VALID_ENDTIME=@VALID_ENDTIME,");
strSql.Append("ENTRY_TIME=@ENTRY_TIME,");
strSql.Append("ABORT_TIME=@ABORT_TIME,");
strSql.Append("ADDRESS=@ADDRESS,");
strSql.Append("PHOTO=@PHOTO,");
strSql.Append("CER_PHOTO_FRONT=@CER_PHOTO_FRONT,");
strSql.Append("CER_PHOTO_BACK=@CER_PHOTO_BACK,");
strSql.Append("PRINT_TEMPLET_ID=@PRINT_TEMPLET_ID,");
strSql.Append("IS_FORBIDDEN=@IS_FORBIDDEN,");
strSql.Append("IS_DELETE=@IS_DELETE,");
strSql.Append("REG_TIME=@REG_TIME,");
strSql.Append("DEL_TIME=@DEL_TIME,");
strSql.Append("FORBIDDEN_TIME=@FORBIDDEN_TIME,");
strSql.Append("ENABLE_TIME=@ENABLE_TIME,");
strSql.Append("MODIFY_TIME=@MODIFY_TIME,");
strSql.Append("STAFF_TYPE=@STAFF_TYPE");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ORG_ID", SqlDbType.Decimal, 9),
new SqlParameter("@STAFF_NO_TEMPLET", SqlDbType.Decimal, 9),
new SqlParameter("@STAFF_NO", SqlDbType.NVarChar, 400),
new SqlParameter("@REAL_NAME", SqlDbType.NVarChar, 100),
new SqlParameter("@SEX", SqlDbType.TinyInt, 1),
new SqlParameter("@JOB", SqlDbType.NVarChar, 200),
new SqlParameter("@BIRTHDAY", SqlDbType.Date, 3),
new SqlParameter("@POLITICS", SqlDbType.NVarChar, 100),
new SqlParameter("@MARRIED", SqlDbType.TinyInt, 1),
new SqlParameter("@SKIIL_LEVEL", SqlDbType.NVarChar, 100),
new SqlParameter("@CER_NAME", SqlDbType.NVarChar, 100),
new SqlParameter("@CER_NO", SqlDbType.NVarChar, 400),
new SqlParameter("@TELE_PHONE", SqlDbType.NVarChar, 100),
new SqlParameter("@CELL_PHONE", SqlDbType.NVarChar, 100),
new SqlParameter("@NATIVE", SqlDbType.NVarChar, 400),
new SqlParameter("@NATION", SqlDbType.NVarChar, 100),
new SqlParameter("@RELIGION", SqlDbType.NVarChar, 100),
new SqlParameter("@EDUCATIONAL", SqlDbType.NVarChar, 100),
new SqlParameter("@EMAIL", SqlDbType.NVarChar, 100),
new SqlParameter("@VALID_STARTTIME", SqlDbType.DateTime),
new SqlParameter("@VALID_ENDTIME", SqlDbType.DateTime),
new SqlParameter("@ENTRY_TIME", SqlDbType.Date, 3),
new SqlParameter("@ABORT_TIME", SqlDbType.Date, 3),
new SqlParameter("@ADDRESS", SqlDbType.NVarChar, 400),
new SqlParameter("@PHOTO", SqlDbType.Image),
new SqlParameter("@CER_PHOTO_FRONT", SqlDbType.Image),
new SqlParameter("@CER_PHOTO_BACK", SqlDbType.Image),
new SqlParameter("@PRINT_TEMPLET_ID", SqlDbType.Decimal, 9),
new SqlParameter("@IS_FORBIDDEN", SqlDbType.Bit, 1),
new SqlParameter("@IS_DELETE", SqlDbType.Bit, 1),
new SqlParameter("@REG_TIME", SqlDbType.DateTime),
new SqlParameter("@DEL_TIME", SqlDbType.DateTime),
new SqlParameter("@FORBIDDEN_TIME", SqlDbType.DateTime),
new SqlParameter("@ENABLE_TIME", SqlDbType.DateTime),
new SqlParameter("@MODIFY_TIME", SqlDbType.DateTime),
new SqlParameter("@STAFF_TYPE", SqlDbType.VarChar, 20),
new SqlParameter("@ID", SqlDbType.Decimal, 9)
};
parameters[0].Value = model.ORG_ID;
parameters[1].Value = model.STAFF_NO_TEMPLET;
parameters[2].Value = model.STAFF_NO;
parameters[3].Value = model.REAL_NAME;
parameters[4].Value = model.SEX;
parameters[5].Value = model.JOB;
parameters[6].Value = model.BIRTHDAY;
parameters[7].Value = model.POLITICS;
parameters[8].Value = model.MARRIED;
parameters[9].Value = model.SKIIL_LEVEL;
parameters[10].Value = model.CER_NAME;
parameters[11].Value = model.CER_NO;
parameters[12].Value = model.TELE_PHONE;
parameters[13].Value = model.CELL_PHONE;
parameters[14].Value = model.NATIVE;
parameters[15].Value = model.NATION;
parameters[16].Value = model.RELIGION;
parameters[17].Value = model.EDUCATIONAL;
parameters[18].Value = model.EMAIL;
parameters[19].Value = model.VALID_STARTTIME;
parameters[20].Value = model.VALID_ENDTIME;
parameters[21].Value = model.ENTRY_TIME;
parameters[22].Value = model.ABORT_TIME;
parameters[23].Value = model.ADDRESS;
parameters[24].Value = model.PHOTO;
parameters[25].Value = model.CER_PHOTO_FRONT;
parameters[26].Value = model.CER_PHOTO_BACK;
parameters[27].Value = model.PRINT_TEMPLET_ID;
parameters[28].Value = model.IS_FORBIDDEN;
parameters[29].Value = model.IS_DELETE;
parameters[30].Value = model.REG_TIME;
parameters[31].Value = model.DEL_TIME;
parameters[32].Value = model.FORBIDDEN_TIME;
parameters[33].Value = model.ENABLE_TIME;
parameters[34].Value = model.MODIFY_TIME;
parameters[35].Value = model.STAFF_TYPE;
parameters[36].Value = model.ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public FrmAddModifyStaffFaceDevPrivate(Maticsoft.Model.SMT_STAFF_INFO staff, bool imageChanged)
{
InitializeComponent();
_staffInfo = staff;
_imageChanged = imageChanged;
}
