public void Update(ClientMemberInfo info) { if (!this.isSubTable) { db.Open(); } string query = " UPDATE [dbo].[ClientMember] SET " + " [RowNo] = @RowNo " + ", [MemberType] = @MemberType " + ", [Name] = @Name " + ", [Nationality] = @Nationality " + ", [IdentityNo] = @IdentityNo " + ", [ContactNo] = @ContactNo " + ", [Address] = @Address " + ", [CreateDate] = @CreateDate " + ", [CreateUser] = @CreateUser " + ", [LastModifiedDate] = @LastModifiedDate " + ", [LastModifiedUser] = @LastModifiedUser " + " where ClientID = @ClientID and RowNo = @RowNo "; db.Execute(query, info, this.transaction); if (!this.isSubTable) { db.Close(); } }
public void Save(ClientMemberInfo info) { if (this.IsExisted(info)) { this.Update(info); } else { this.Insert(info); } }
public bool IsExisted(ClientMemberInfo info) { if (!this.isSubTable) { db.Open(); } String query = "select count(*) from ClientMember " + " where ClientID = @ClientID and RowNo = @RowNo "; var obj = (List <int>)db.Query <int>(query, info, this.transaction); if (!this.isSubTable) { db.Close(); } return(obj[0] > 0); }
public void Insert(ClientMemberInfo info) { if (!this.isSubTable) { db.Open(); } string query = "INSERT INTO [dbo].[ClientMember] ( [ClientID] " + ",[RowNo] " + ",[MemberType] " + ",[Name] " + ",[Nationality] " + ",[IdentityNo] " + ",[ContactNo] " + ",[Address] " + ",[CreateDate] " + ",[CreateUser] " + ",[LastModifiedDate] " + ",[LastModifiedUser] " + ") " + "VALUES ( @ClientID " + ",@RowNo " + ",@MemberType " + ",@Name " + ",@Nationality " + ",@IdentityNo " + ",@ContactNo " + ",@Address " + ",@CreateDate " + ",@CreateUser " + ",@LastModifiedDate " + ",@LastModifiedUser " + ") "; db.Execute(query, info, this.transaction); if (!this.isSubTable) { db.Close(); } }