public bool InsertRecord(Sys_UserMaster_usm infoObject)
{
//throw new NotImplementedException();
string Sql = " INSERT INTO [Sys_UserMaster_usm] " + Environment.NewLine;
Sql = Sql + "([usm_cUserLoginID]" + Environment.NewLine;
Sql = Sql + ",[usm_cChaName]" + Environment.NewLine;
Sql = Sql + ",[usm_cPasswork]" + Environment.NewLine;
Sql = Sql + " ,[usm_cEMail]" + Environment.NewLine;
Sql = Sql + ",[usm_iLock]" + Environment.NewLine;
Sql = Sql + ",[usm_cRemark]" + Environment.NewLine;
Sql = Sql + ",[usm_cAdd]" + Environment.NewLine;
Sql = Sql + ",[usm_dAddDate]" + Environment.NewLine;
Sql = Sql + ",[usm_cLast]" + Environment.NewLine;
Sql = Sql + ",[usm_dLastDate])" + Environment.NewLine;
Sql = Sql + "VALUES" + Environment.NewLine;
Sql = Sql + "('"+infoObject.usm_cUserLoginID +"'" + Environment.NewLine;
Sql = Sql + ",'" + infoObject.usm_cChaName + "'" + Environment.NewLine;
Sql = Sql + ",'" + infoObject.usm_cPasswork + "'" + Environment.NewLine;
Sql = Sql + ",'" + infoObject.usm_cEMail + "'" + Environment.NewLine;
Sql = Sql + "," +(infoObject.usm_iLock ? 1 :0) + Environment.NewLine;
Sql = Sql + ",'" + infoObject.usm_cRemark + "'" + Environment.NewLine;
Sql = Sql + ",'" + infoObject.usm_cAdd + "'" + Environment.NewLine;
Sql = Sql + ",'" + infoObject.usm_dAddDate.Value.ToString(Common.DefineConstantValue.gc_DateFormat) + "'" + Environment.NewLine;
Sql = Sql + ",'" + infoObject.usm_cLast + "'" + Environment.NewLine;
Sql = Sql + ",'" + infoObject.usm_dLastDate.Value.ToString(Common.DefineConstantValue.gc_DateFormat) + "')" + Environment.NewLine;
return false;
}
public bool UpdateRecord(Sys_UserMaster_usm infoObject)
{
throw new NotImplementedException();
}
