/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.SMT_WEEKEX_INFO model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update SMT_WEEKEX_INFO set ");
strSql.Append("WEEKEX_DESC=@WEEKEX_DESC,");
strSql.Append("WEEKEX_ON_DUTY=@WEEKEX_ON_DUTY,");
strSql.Append("WEEKEX_START_DATE=@WEEKEX_START_DATE,");
strSql.Append("WEEKEX_END_DATE=@WEEKEX_END_DATE");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@WEEKEX_DESC", SqlDbType.NVarChar, 200),
new SqlParameter("@WEEKEX_ON_DUTY", SqlDbType.Bit, 1),
new SqlParameter("@WEEKEX_START_DATE", SqlDbType.DateTime),
new SqlParameter("@WEEKEX_END_DATE", SqlDbType.DateTime),
new SqlParameter("@ID", SqlDbType.Decimal, 9)
};
parameters[0].Value = model.WEEKEX_DESC;
parameters[1].Value = model.WEEKEX_ON_DUTY;
parameters[2].Value = model.WEEKEX_START_DATE;
parameters[3].Value = model.WEEKEX_END_DATE;
parameters[4].Value = model.ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
private void dgvData_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex >= 0 && e.RowIndex >= 0)
{
if (dgvData.Columns[e.ColumnIndex].Name == "ColDelete")
{
Maticsoft.Model.SMT_WEEKEX_INFO info = (Maticsoft.Model.SMT_WEEKEX_INFO)dgvData.Rows[e.RowIndex].Tag;
if (MessageBox.Show("确定删除该假期约束？", "提示", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
CtrlWaiting waiting = new CtrlWaiting(() =>
{
try
{
Maticsoft.BLL.SMT_WEEKEX_INFO wbll = new Maticsoft.BLL.SMT_WEEKEX_INFO();
wbll.Delete(info.ID);
SmtLog.InfoFormat("设置", "删除假期约束：{0},开始时间：{1},结束时间：{2},描述：{3}", info.WEEKEX_ON_DUTY ? "上班[允许开门]" : "假期[不能开门]", info.WEEKEX_START_DATE, info.WEEKEX_END_DATE, info.WEEKEX_DESC);
this.Invoke(new Action(() =>
{
dgvData.Rows.Remove(dgvData.Rows[e.RowIndex]);
}));
}
catch (System.Exception ex)
{
WinInfoHelper.ShowInfoWindow(this, "删除假期约束异常：" + ex.Message);
log.Error("删除假期约束异常：", ex);
}
});
waiting.Show(this);
}
}
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public decimal Add(Maticsoft.Model.SMT_WEEKEX_INFO model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SMT_WEEKEX_INFO(");
strSql.Append("WEEKEX_DESC,WEEKEX_ON_DUTY,WEEKEX_START_DATE,WEEKEX_END_DATE)");
strSql.Append(" values (");
strSql.Append("@WEEKEX_DESC,@WEEKEX_ON_DUTY,@WEEKEX_START_DATE,@WEEKEX_END_DATE)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@WEEKEX_DESC", SqlDbType.NVarChar, 200),
new SqlParameter("@WEEKEX_ON_DUTY", SqlDbType.Bit, 1),
new SqlParameter("@WEEKEX_START_DATE", SqlDbType.DateTime),
new SqlParameter("@WEEKEX_END_DATE", SqlDbType.DateTime)
};
parameters[0].Value = model.WEEKEX_DESC;
parameters[1].Value = model.WEEKEX_ON_DUTY;
parameters[2].Value = model.WEEKEX_START_DATE;
parameters[3].Value = model.WEEKEX_END_DATE;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToDecimal(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.SMT_WEEKEX_INFO DataRowToModel(DataRow row)
{
Maticsoft.Model.SMT_WEEKEX_INFO model = new Maticsoft.Model.SMT_WEEKEX_INFO();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = decimal.Parse(row["ID"].ToString());
}
if (row["WEEKEX_DESC"] != null)
{
model.WEEKEX_DESC = row["WEEKEX_DESC"].ToString();
}
if (row["WEEKEX_ON_DUTY"] != null && row["WEEKEX_ON_DUTY"].ToString() != "")
{
if ((row["WEEKEX_ON_DUTY"].ToString() == "1") || (row["WEEKEX_ON_DUTY"].ToString().ToLower() == "true"))
{
model.WEEKEX_ON_DUTY = true;
}
else
{
model.WEEKEX_ON_DUTY = false;
}
}
if (row["WEEKEX_START_DATE"] != null && row["WEEKEX_START_DATE"].ToString() != "")
{
model.WEEKEX_START_DATE = DateTime.Parse(row["WEEKEX_START_DATE"].ToString());
}
if (row["WEEKEX_END_DATE"] != null && row["WEEKEX_END_DATE"].ToString() != "")
{
model.WEEKEX_END_DATE = DateTime.Parse(row["WEEKEX_END_DATE"].ToString());
}
}
return(model);
}
private void AddToGrid(Maticsoft.Model.SMT_WEEKEX_INFO info)
{
DataGridViewRow row = new DataGridViewRow();
row.CreateCells(dgvData,
info.WEEKEX_ON_DUTY ? "上班[允许开门]" : "假期[不能开门]",
info.WEEKEX_START_DATE,
info.WEEKEX_END_DATE,
info.WEEKEX_DESC,
"删除"
);
row.Tag = info;
dgvData.Rows.Add(row);
}
private void btnAdd_Click(object sender, EventArgs e)
{
DateTime dtStart = DateTime.Parse(dtpStartDate.Value.ToString("yyyy-MM-dd HH:mm:00"));
DateTime dtEnd = DateTime.Parse(dtpEndDate.Value.ToString("yyyy-MM-dd HH:mm:00"));
if (dtStart > dtEnd)
{
WinInfoHelper.ShowInfoWindow(this, "开始时间大于结束时间！");
return;
}
Maticsoft.Model.SMT_WEEKEX_INFO info = new Maticsoft.Model.SMT_WEEKEX_INFO();
info.WEEKEX_ON_DUTY = cboHolidayType.SelectedIndex == 1;
info.WEEKEX_START_DATE = dtStart;
info.WEEKEX_END_DATE = dtEnd;
info.WEEKEX_DESC = tbDesc.Text.Trim();
CtrlWaiting waiting = new CtrlWaiting(() =>
{
try
{
Maticsoft.BLL.SMT_WEEKEX_INFO wbll = new Maticsoft.BLL.SMT_WEEKEX_INFO();
info.ID = wbll.Add(info);
SmtLog.InfoFormat("设置", "添加假期约束：{0},开始时间：{1},结束时间：{2},描述：{3}", info.WEEKEX_ON_DUTY ? "上班[允许开门]" : "假期[不能开门]", info.WEEKEX_START_DATE, info.WEEKEX_END_DATE, info.WEEKEX_DESC);
this.Invoke(new Action(() =>
{
AddToGrid(info);
}));
}
catch (System.Exception ex)
{
WinInfoHelper.ShowInfoWindow(this, "添加假期约束异常：" + ex.Message);
log.Error("添加假期约束异常：", ex);
}
});
waiting.Show(this);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.SMT_WEEKEX_INFO GetModel(decimal ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,WEEKEX_DESC,WEEKEX_ON_DUTY,WEEKEX_START_DATE,WEEKEX_END_DATE from SMT_WEEKEX_INFO ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Decimal)
};
parameters[0].Value = ID;
Maticsoft.Model.SMT_WEEKEX_INFO model = new Maticsoft.Model.SMT_WEEKEX_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);
}
}
