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(); }