public static int InsertCustomerTopicInfo(CustomerTopicInfo info) { SqlParameter[] parms = new SqlParameter[] { new SqlParameter("@CustomerSysNo", SqlDbType.Int), }; parms[0].Value = info.CustomerSysNo; SqlCommand cmd = new SqlCommand(SQL_INSERT_CUSTOMERTOPICINFO); cmd.Parameters.AddRange(parms); cmd.CommandTimeout = 180; object obj = SqlHelper.ExecuteScalar(cmd); return Convert.ToInt32(obj); }
protected static CustomerTopicInfo Map(DataRow row) { CustomerTopicInfo info = new CustomerTopicInfo(); info.SysNo = Convert.ToInt32(row["SysNo"]); info.CustomerSysNo = Convert.ToInt32(row["CustomerSysNo"]); info.TopicCount = Convert.ToInt32(row["TopicCount"]); info.DigestCount = Convert.ToInt32(row["DigestCount"]); info.ReplyCount = Convert.ToInt32(row["ReplyCount"]); info.RemarkCount = Convert.ToInt32(row["RemarkCount"]); info.LastEditUserSysNo = Convert.ToInt32(row["LastEditUserSysNo"]); info.LastEditDate = Convert.ToDateTime(row["LastEditDate"]); return info; }