public string SaveMaster(string pk, string userPk, string title) { DefinedFormManager dfm = new DefinedFormManager(); int iPk, iUserPk; int.TryParse(pk, out iPk); int.TryParse(userPk, out iUserPk); var data = new DefinedFormData { PK = iPk, CompanyId = 0, CreateDate = DateTime.Now, UserModulePK = iUserPk, Title = title }; if (pk == "0") { pk = dfm.Insert(data); } else { dfm.Update(data); } return(pk); }
private DefinedFormData GetDefindedForm(SqlDataReader dr) { DefinedFormData data = new DefinedFormData(); data.PK = ((int)(dr["PK"])); data.CompanyId = ((int)(dr["CompanyId"])); data.UserModulePK = ((int)(dr["UserModulePK"])); data.CreateDate = ((DateTime)(dr["CreateDate"])); data.Title = dr["Title"].ToString(); return(data); }
public virtual void Update(DefinedFormData data) { string sqlStr; SqlCommand cmd; sqlStr = "Update DefinedForm Set CompanyId= @CompanyId,UserModulePK= @UserModulePK,CreateD" + "ate= @CreateDate, Title=@Title Where PK =@PK"; cmd = new SqlCommand(sqlStr, this.mCon); cmd.Parameters.AddWithValue("@CompanyId", data.CompanyId); cmd.Parameters.AddWithValue("@UserModulePK", data.UserModulePK); cmd.Parameters.AddWithValue("@CreateDate", data.CreateDate); cmd.Parameters.AddWithValue("@Title", data.Title); cmd.Parameters.AddWithValue("@PK", data.PK); this.mCon.Open(); cmd.ExecuteNonQuery(); this.mCon.Close(); cmd.Dispose(); }
public string Insert(DefinedFormData data) { string sqlStr; SqlCommand cmd; sqlStr = "Insert Into DefinedForm(CompanyId,UserModulePK,CreateDate,Title) Values(@Compan" + "yId,@UserModulePK,@CreateDate, @Title) SET @QPk = SCOPE_IDENTITY()"; cmd = new SqlCommand(sqlStr, this.mCon); cmd.Parameters.AddWithValue("@CompanyId", data.CompanyId); cmd.Parameters.AddWithValue("@UserModulePK", data.UserModulePK); cmd.Parameters.AddWithValue("@CreateDate", data.CreateDate); cmd.Parameters.AddWithValue("@Title", data.Title); var para = new SqlParameter("@QPk", SqlDbType.Int); para.Direction = ParameterDirection.Output; cmd.Parameters.Add(para); this.mCon.Open(); cmd.ExecuteNonQuery(); this.mCon.Close(); cmd.Dispose(); return(para.Value.ToString()); }