public DisarmTimeEditViewModel(DisarmTimeListViewModel _vm, DisarmTimeEditView _mw)
{
_DisarmTimeListVM = _vm;
_Window = _mw;
OperationType = OpType.Add;
DisarmTimeObj = new DisarmTimeOR();
//UpdatetxtSource(_Window.gridContent);
}
public DisarmTimeEditViewModel(DisarmTimeListViewModel _vm, DisarmTimeEditView _mw, DisarmTimeOR _DisarmTimeObj)
{
_DisarmTimeListVM = _vm;
_Window = _mw;
_SourceObj = _DisarmTimeObj;
OperationType = OpType.Alert;
DisarmTimeObj = new DisarmTimeOR();
DisarmTimeObj.Clone(_DisarmTimeObj);
}
/// <summary>
/// 插入t_DisarmTime
/// </summary>
public virtual bool Insert(DisarmTimeOR disarmTime)
{
string sql = "insert into t_DisarmTime (DisarmName, DisarmStartTime, DisarmEndTime) values(@DisarmName, @DisarmStartTime, @DisarmEndTime)";
SqlParameter[] parameters = new SqlParameter[]
{
//new SqlParameter("@DisarmID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "DisarmID", DataRowVersion.Default, disarmTime.Disarmid),
new SqlParameter("@DisarmName", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "DisarmName", DataRowVersion.Default, disarmTime.Disarmname),
new SqlParameter("@DisarmStartTime", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "DisarmStartTime", DataRowVersion.Default, disarmTime.Disarmstarttime),
new SqlParameter("@DisarmEndTime", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "DisarmEndTime", DataRowVersion.Default, disarmTime.Disarmendtime)
};
return db.ExecuteNoQuery(sql, parameters) > -1;
}
public ObservableCollection<DisarmTimeOR> selectAllDate()
{
string sql = "select * from t_DisarmTime";
DataTable dt = null;
try
{
dt = db.ExecuteQuery(sql);
}
catch (Exception ex)
{
throw ex;
}
ObservableCollection<DisarmTimeOR> _List = new ObservableCollection<DisarmTimeOR>();
foreach (DataRow dr in dt.Rows)
{
DisarmTimeOR obj = new DisarmTimeOR(dr);
_List.Add(obj);
}
return _List;
}
public void Clone(DisarmTimeOR obj)
{
//
Disarmid = obj.Disarmid;
//撤防名称
Disarmname = obj.Disarmname;
//撤防开始时间
Disarmstarttime = obj.Disarmstarttime;
//撤防结束时间
Disarmendtime = obj.Disarmendtime;
}
public DisarmTimeEditView(DisarmTimeListViewModel _List, DisarmTimeOR _DisarmTime)
{
InitializeComponent();
this.DataContext = new DisarmTimeEditViewModel(_List, this, _DisarmTime);
}
public DisarmTimeEditViewModel(DisarmTimeOR _Sta)
{
OperationType = OpType.Alert;
DisarmTimeObj = _Sta;
}
public DisarmTimeOR selectARowDate(string m_id)
{
string sql = string.Format("select * from t_DisarmTime where Disarmid='{0}'", m_id);
DataTable dt = null;
try
{
dt = db.ExecuteQueryDataSet(sql).Tables[0];
}
catch (Exception ex)
{
throw ex;
}
if (dt == null)
return null;
if (dt.Rows.Count == 0)
return null;
DataRow dr = dt.Rows[0];
DisarmTimeOR m_Disa = new DisarmTimeOR(dr);
return m_Disa;
}
/// <summary>
/// 更新t_DisarmTime
/// </summary>
public virtual bool Update(DisarmTimeOR disarmTime)
{
string sql = "update t_DisarmTime set DisarmName = @DisarmName, DisarmStartTime = @DisarmStartTime, DisarmEndTime = @DisarmEndTime where DisarmID = @DisarmID";
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@DisarmID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "DisarmID", DataRowVersion.Default, disarmTime.Disarmid),
new SqlParameter("@DisarmName", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "DisarmName", DataRowVersion.Default, disarmTime.Disarmname),
new SqlParameter("@DisarmStartTime", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "DisarmStartTime", DataRowVersion.Default, disarmTime.Disarmstarttime),
new SqlParameter("@DisarmEndTime", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "DisarmEndTime", DataRowVersion.Default, disarmTime.Disarmendtime)
};
return db.ExecuteNoQuery(sql, parameters) > -1;
}