/// <summary>
/// 增加一条数据
/// </summary>
public decimal Add(Maticsoft.Model.SMT_CTRLR_TASK model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SMT_CTRLR_TASK(");
strSql.Append("TASK_NO,TASK_NAME,VALID_STARTDATE,VALID_ENDDATE,ACTION_TIME,MON_STATE,TUE_STATE,THI_STATE,WES_STATE,FRI_STATE,SAT_STATE,SUN_STATE,DOOR_ID,CTRL_STYLE,TASK_DESC)");
strSql.Append(" values (");
strSql.Append("@TASK_NO,@TASK_NAME,@VALID_STARTDATE,@VALID_ENDDATE,@ACTION_TIME,@MON_STATE,@TUE_STATE,@THI_STATE,@WES_STATE,@FRI_STATE,@SAT_STATE,@SUN_STATE,@DOOR_ID,@CTRL_STYLE,@TASK_DESC)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@TASK_NO", SqlDbType.VarChar, 20),
new SqlParameter("@TASK_NAME", SqlDbType.NVarChar, 200),
new SqlParameter("@VALID_STARTDATE", SqlDbType.Date, 3),
new SqlParameter("@VALID_ENDDATE", SqlDbType.Date, 3),
new SqlParameter("@ACTION_TIME", SqlDbType.Time, 5),
new SqlParameter("@MON_STATE", SqlDbType.Bit, 1),
new SqlParameter("@TUE_STATE", SqlDbType.Bit, 1),
new SqlParameter("@THI_STATE", SqlDbType.Bit, 1),
new SqlParameter("@WES_STATE", SqlDbType.Bit, 1),
new SqlParameter("@FRI_STATE", SqlDbType.Bit, 1),
new SqlParameter("@SAT_STATE", SqlDbType.Bit, 1),
new SqlParameter("@SUN_STATE", SqlDbType.Bit, 1),
new SqlParameter("@DOOR_ID", SqlDbType.VarChar, 5000),
new SqlParameter("@CTRL_STYLE", SqlDbType.TinyInt, 1),
new SqlParameter("@TASK_DESC", SqlDbType.NVarChar, 200)
};
parameters[0].Value = model.TASK_NO;
parameters[1].Value = model.TASK_NAME;
parameters[2].Value = model.VALID_STARTDATE;
parameters[3].Value = model.VALID_ENDDATE;
parameters[4].Value = model.ACTION_TIME;
parameters[5].Value = model.MON_STATE;
parameters[6].Value = model.TUE_STATE;
parameters[7].Value = model.THI_STATE;
parameters[8].Value = model.WES_STATE;
parameters[9].Value = model.FRI_STATE;
parameters[10].Value = model.SAT_STATE;
parameters[11].Value = model.SUN_STATE;
parameters[12].Value = model.DOOR_ID;
parameters[13].Value = model.CTRL_STYLE;
parameters[14].Value = model.TASK_DESC;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToDecimal(obj));
}
}
private List <Maticsoft.Model.SMT_CTRLR_TASK> GetTasks(bool all = true)
{
List <Maticsoft.Model.SMT_CTRLR_TASK> tasks = new List <Maticsoft.Model.SMT_CTRLR_TASK>();
if (all)//所有任务
{
foreach (DataGridViewRow row in dgvData.Rows)
{
tasks.Add((Maticsoft.Model.SMT_CTRLR_TASK)row.Tag);
}
}
else
{
var rows = dgvData.SelectedRows;
if (rows.Count > 0)
{
foreach (DataGridViewRow row in rows)
{
tasks.Add((Maticsoft.Model.SMT_CTRLR_TASK)row.Tag);
}
}
else
{
var cells = dgvData.SelectedCells;
if (cells.Count > 0)
{
foreach (DataGridViewCell item in cells)
{
int rowIndex = item.RowIndex;
if (rowIndex >= 0)
{
Maticsoft.Model.SMT_CTRLR_TASK task = (Maticsoft.Model.SMT_CTRLR_TASK)dgvData.Rows[rowIndex].Tag;
if (!tasks.Contains(task))
{
tasks.Add(task);
}
}
}
}
}
}
return(tasks);
}
private void AddData(Maticsoft.Model.SMT_CTRLR_TASK info)
{
DataGridViewRow row = new DataGridViewRow();
row.CreateCells(dgvData,
info.TASK_NO,
info.TASK_NAME,
info.VALID_STARTDATE.Date,
info.VALID_ENDDATE.Date,
info.ACTION_TIME,
info.MON_STATE,
info.TUE_STATE,
info.THI_STATE,
info.WES_STATE,
info.FRI_STATE,
info.SAT_STATE,
info.SUN_STATE,
info.DOOR_NAMES, //
info.STR_CTRL_STYLE, //
info.TASK_DESC
);
row.Tag = info;
dgvData.Rows.Add(row);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.SMT_CTRLR_TASK GetModel(decimal ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,TASK_NO,TASK_NAME,VALID_STARTDATE,VALID_ENDDATE,ACTION_TIME,MON_STATE,TUE_STATE,THI_STATE,WES_STATE,FRI_STATE,SAT_STATE,SUN_STATE,DOOR_ID,CTRL_STYLE,TASK_DESC from SMT_CTRLR_TASK ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Decimal)
};
parameters[0].Value = ID;
Maticsoft.Model.SMT_CTRLR_TASK model = new Maticsoft.Model.SMT_CTRLR_TASK();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
public FrmCtrlTaskEditor(Maticsoft.Model.SMT_CTRLR_TASK task = null, bool isview = false)
{
InitializeComponent();
_task = task;
_isview = isview;
}
private void btnOk_Click(object sender, EventArgs e)
{
if (_isview)
{
this.Close();
return;
}
if (string.IsNullOrWhiteSpace(tbTaskName.Text))
{
WinInfoHelper.ShowInfoWindow(this, "任务名称不能为空！");
return;
}
string doorId = "-1";
if (doorTree.Nodes[0].CheckState != CheckState.Checked)
{
doorId = "";
var nodes = doorTree.GetNodeList(true, typeof(Maticsoft.Model.SMT_DOOR_INFO));
if (nodes.Count == 0)
{
WinInfoHelper.ShowInfoWindow(this, "未选择门禁！");
return;
}
foreach (var item in nodes)
{
doorId += ((Maticsoft.Model.SMT_DOOR_INFO)item.Tag).ID + ",";
}
doorId = doorId.TrimEnd(',');
}
if (_task == null)
{
_task = new Maticsoft.Model.SMT_CTRLR_TASK();
_task.ID = -1;
}
_task.DOOR_ID = doorId;
_task.TASK_NO = tbTaskNum.Text.Trim();
_task.TASK_NAME = tbTaskName.Text.Trim();
_task.TASK_DESC = tbTaskDesc.Text;
_task.VALID_STARTDATE = dtpStartDate.Value.Date;
_task.VALID_ENDDATE = dtpEndDate.Value.Date;
_task.ACTION_TIME = new TimeSpan(dtiTime.Value.Hour, dtiTime.Value.Minute, dtiTime.Value.Second);
_task.CTRL_STYLE = cboCtrlStyle.SelectedIndex;
_task.MON_STATE = cbWeek1.Checked;
_task.TUE_STATE = cbWeek2.Checked;
_task.THI_STATE = cbWeek3.Checked;
_task.WES_STATE = cbWeek4.Checked;
_task.FRI_STATE = cbWeek5.Checked;
_task.SAT_STATE = cbWeek6.Checked;
_task.SUN_STATE = cbWeek7.Checked;
_task.DOOR_NAMES = tbDoorDropDown.Text;
CtrlWaiting waiting = new CtrlWaiting(() =>
{
try
{
Maticsoft.BLL.SMT_CTRLR_TASK taskBll = new Maticsoft.BLL.SMT_CTRLR_TASK();
if (_task.ID == -1)
{
_task.ID = taskBll.Add(_task);
}
else
{
taskBll.Update(_task);
}
this.BeginInvoke(new Action(() =>
{
this.DialogResult = DialogResult.OK;
this.Close();
}));
}
catch (Exception ex)
{
log.Error("保存异常：", ex);
WinInfoHelper.ShowInfoWindow(this, "保存任务异常：" + ex.Message);
}
});
waiting.Show(this);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.SMT_CTRLR_TASK DataRowToModel(DataRow row)
{
Maticsoft.Model.SMT_CTRLR_TASK model = new Maticsoft.Model.SMT_CTRLR_TASK();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = decimal.Parse(row["ID"].ToString());
}
if (row["TASK_NO"] != null)
{
model.TASK_NO = row["TASK_NO"].ToString();
}
if (row["TASK_NAME"] != null)
{
model.TASK_NAME = row["TASK_NAME"].ToString();
}
if (row["VALID_STARTDATE"] != null && row["VALID_STARTDATE"].ToString() != "")
{
model.VALID_STARTDATE = DateTime.Parse(row["VALID_STARTDATE"].ToString());
}
if (row["VALID_ENDDATE"] != null && row["VALID_ENDDATE"].ToString() != "")
{
model.VALID_ENDDATE = DateTime.Parse(row["VALID_ENDDATE"].ToString());
}
if (row["ACTION_TIME"] != null && row["ACTION_TIME"].ToString() != "")
{
model.ACTION_TIME = TimeSpan.Parse(row["ACTION_TIME"].ToString());
}
if (row["MON_STATE"] != null && row["MON_STATE"].ToString() != "")
{
if ((row["MON_STATE"].ToString() == "1") || (row["MON_STATE"].ToString().ToLower() == "true"))
{
model.MON_STATE = true;
}
else
{
model.MON_STATE = false;
}
}
if (row["TUE_STATE"] != null && row["TUE_STATE"].ToString() != "")
{
if ((row["TUE_STATE"].ToString() == "1") || (row["TUE_STATE"].ToString().ToLower() == "true"))
{
model.TUE_STATE = true;
}
else
{
model.TUE_STATE = false;
}
}
if (row["THI_STATE"] != null && row["THI_STATE"].ToString() != "")
{
if ((row["THI_STATE"].ToString() == "1") || (row["THI_STATE"].ToString().ToLower() == "true"))
{
model.THI_STATE = true;
}
else
{
model.THI_STATE = false;
}
}
if (row["WES_STATE"] != null && row["WES_STATE"].ToString() != "")
{
if ((row["WES_STATE"].ToString() == "1") || (row["WES_STATE"].ToString().ToLower() == "true"))
{
model.WES_STATE = true;
}
else
{
model.WES_STATE = false;
}
}
if (row["FRI_STATE"] != null && row["FRI_STATE"].ToString() != "")
{
if ((row["FRI_STATE"].ToString() == "1") || (row["FRI_STATE"].ToString().ToLower() == "true"))
{
model.FRI_STATE = true;
}
else
{
model.FRI_STATE = false;
}
}
if (row["SAT_STATE"] != null && row["SAT_STATE"].ToString() != "")
{
if ((row["SAT_STATE"].ToString() == "1") || (row["SAT_STATE"].ToString().ToLower() == "true"))
{
model.SAT_STATE = true;
}
else
{
model.SAT_STATE = false;
}
}
if (row["SUN_STATE"] != null && row["SUN_STATE"].ToString() != "")
{
if ((row["SUN_STATE"].ToString() == "1") || (row["SUN_STATE"].ToString().ToLower() == "true"))
{
model.SUN_STATE = true;
}
else
{
model.SUN_STATE = false;
}
}
if (row["DOOR_ID"] != null)
{
model.DOOR_ID = row["DOOR_ID"].ToString();
}
if (row["CTRL_STYLE"] != null && row["CTRL_STYLE"].ToString() != "")
{
model.CTRL_STYLE = int.Parse(row["CTRL_STYLE"].ToString());
}
if (row["TASK_DESC"] != null)
{
model.TASK_DESC = row["TASK_DESC"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.SMT_CTRLR_TASK model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update SMT_CTRLR_TASK set ");
strSql.Append("TASK_NO=@TASK_NO,");
strSql.Append("TASK_NAME=@TASK_NAME,");
strSql.Append("VALID_STARTDATE=@VALID_STARTDATE,");
strSql.Append("VALID_ENDDATE=@VALID_ENDDATE,");
strSql.Append("ACTION_TIME=@ACTION_TIME,");
strSql.Append("MON_STATE=@MON_STATE,");
strSql.Append("TUE_STATE=@TUE_STATE,");
strSql.Append("THI_STATE=@THI_STATE,");
strSql.Append("WES_STATE=@WES_STATE,");
strSql.Append("FRI_STATE=@FRI_STATE,");
strSql.Append("SAT_STATE=@SAT_STATE,");
strSql.Append("SUN_STATE=@SUN_STATE,");
strSql.Append("DOOR_ID=@DOOR_ID,");
strSql.Append("CTRL_STYLE=@CTRL_STYLE,");
strSql.Append("TASK_DESC=@TASK_DESC");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@TASK_NO", SqlDbType.VarChar, 20),
new SqlParameter("@TASK_NAME", SqlDbType.NVarChar, 200),
new SqlParameter("@VALID_STARTDATE", SqlDbType.Date, 3),
new SqlParameter("@VALID_ENDDATE", SqlDbType.Date, 3),
new SqlParameter("@ACTION_TIME", SqlDbType.Time, 5),
new SqlParameter("@MON_STATE", SqlDbType.Bit, 1),
new SqlParameter("@TUE_STATE", SqlDbType.Bit, 1),
new SqlParameter("@THI_STATE", SqlDbType.Bit, 1),
new SqlParameter("@WES_STATE", SqlDbType.Bit, 1),
new SqlParameter("@FRI_STATE", SqlDbType.Bit, 1),
new SqlParameter("@SAT_STATE", SqlDbType.Bit, 1),
new SqlParameter("@SUN_STATE", SqlDbType.Bit, 1),
new SqlParameter("@DOOR_ID", SqlDbType.VarChar, 5000),
new SqlParameter("@CTRL_STYLE", SqlDbType.TinyInt, 1),
new SqlParameter("@TASK_DESC", SqlDbType.NVarChar, 200),
new SqlParameter("@ID", SqlDbType.Decimal, 9)
};
parameters[0].Value = model.TASK_NO;
parameters[1].Value = model.TASK_NAME;
parameters[2].Value = model.VALID_STARTDATE;
parameters[3].Value = model.VALID_ENDDATE;
parameters[4].Value = model.ACTION_TIME;
parameters[5].Value = model.MON_STATE;
parameters[6].Value = model.TUE_STATE;
parameters[7].Value = model.THI_STATE;
parameters[8].Value = model.WES_STATE;
parameters[9].Value = model.FRI_STATE;
parameters[10].Value = model.SAT_STATE;
parameters[11].Value = model.SUN_STATE;
parameters[12].Value = model.DOOR_ID;
parameters[13].Value = model.CTRL_STYLE;
parameters[14].Value = model.TASK_DESC;
parameters[15].Value = model.ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
