public bool saveRuleRelation(CusRule cusRule)
{
bool saveMark = true;
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into t_cus_codrule (uuid,cus_no,del_matno,op_user,create_time,bound_type,rule_no)");
strSql.Append("values(@uuid,@cusno,@delmatno,@opuser,@createtime,@boundType,@ruleno)");
MySqlParameter[] parameters =
{
new MySqlParameter("@uuid", MySqlDbType.VarChar, 900),
new MySqlParameter("@cusno", MySqlDbType.VarChar, 900),
new MySqlParameter("@delmatno", MySqlDbType.VarChar, 900),
new MySqlParameter("@opuser", MySqlDbType.VarChar, 900),
new MySqlParameter("@createtime", MySqlDbType.VarChar, 900),
new MySqlParameter("@boundType", MySqlDbType.VarChar, 900),
new MySqlParameter("@ruleno", MySqlDbType.VarChar, 900)
};
parameters[0].Value = cusRule.Uuid;
parameters[1].Value = cusRule.Cusno;
parameters[2].Value = cusRule.Delmatno;
parameters[3].Value = cusRule.Opuser;
parameters[4].Value = cusRule.Createtime;
parameters[5].Value = cusRule.Boundtype;
parameters[6].Value = cusRule.Ruleno;
int rows = SQLHelper.ExecuteNonQuery(SQLHelper.ConnectionString, CommandType.Text, strSql.ToString(), parameters);
if (rows > 0)
{
saveMark = true;
}
else
{
saveMark = false;
}
return(saveMark);
}
/// <summary>
/// 檢查是否已經存在幾種
/// </summary>
/// <param name="cusRule"></param>
/// <returns></returns>
public bool checkAdd(CusRule cusRule)
{
return(cusRuleDao.exists(cusRule));
}
