public bool Update(TMOR mobj)
{
string sql = string.Format("update [TM] set NO='{0}',Name='{1}',ISUse='{2}' where id={3}",
mobj.NO, mobj.Name, mobj.ISUse, mobj.ID);
return db.excuteNonquery(sql);
}
/// <summary>
/// 插入BuyClothes
/// </summary>
public bool Insert(TMOR mobj)
{
string sql = string.Format("insert into [TM] ([NO],[Name],[ISUse]) values ('{0}','{1}','{2}')",
mobj.NO, mobj.Name, mobj.ISUse);
return db.excuteNonquery(sql);
}
public TMOR selectARowDate(string m_id)
{
string sql = string.Format("select * from [TM] where id={0}", m_id);
DataTable dt = null;
try
{
dt = db.executeQuery(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];
TMOR mObj = new TMOR(dr);
return mObj;
}
private TMOR setValue()
{
if (string.IsNullOrEmpty(txtNO.Text)
|| string.IsNullOrEmpty(txtName.Text)
)
{
MessageBox.Show("数据输入不完整。", "提示");
return null;
}
TMOR m_obj = new TMOR();
m_obj.NO =txtNO.Text;
m_obj.Name=txtName.Text;
m_obj.ISUse=cbUse.Checked?"是":"否";
return m_obj;
}
