public static int Insert(kjcCompany model, out string errMsg)
{
sql.Length = rtn = 0;
errMsg = string.Empty;
try
{
sql.Append("Insert Into kjcCompany ");
sql.Append("(regId,regName,regCorpName,organizationCode,regAddress,regPost,contactMan,contactPhone,uDate) ");
sql.AppendFormat("Values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}')",
model.regId, model.regName, model.regCorpName, model.organizationCode, model.regAddress, model.regPost, model.contactMan, model.contactPhone, model.uDate);
DataBase.ExecuteCommand(sql.ToString(), out errMsg);
rtn = 1;
}
catch (Exception e)
{
errMsg = e.Message;
}
return(rtn);
}
public static int Update(kjcCompany model, string where, out string errMsg)
{
sql.Length = rtn = 0;
errMsg = string.Empty;
try
{
//添加where条件
if (where.Length > 0)
{
sql.AppendFormat(" Where {0}", where);
}
DataBase.ExecuteCommand(sql.ToString(), out errMsg);
rtn = 1;
}
catch (Exception e)
{
errMsg = e.Message;
}
return(rtn);
}
