public static UserGroup2User GetUserGroup2UserByID(string pID)
{
try
{
UserGroup2User _UserGroup2User = new UserGroup2User();
DataTable taskDataTable = new DataTable();
using (SqlConnection conn = new SqlConnection(getTmpAppConnectionString()))
{
string sql = " select * from UserGroup2User where ID='" + pID + "' ";
using (SqlDataAdapter sd = new SqlDataAdapter(sql, conn))
{
sd.Fill(taskDataTable);
}
if (taskDataTable.Rows.Count > 0)
{
_UserGroup2User = DataRowToUserGroup2User(taskDataTable.Rows[0]);
}
else
{
_UserGroup2User = null;
}
}
return(_UserGroup2User);
}
catch (Exception ex)
{
LogService.WriteErr("程序错误，方法：GetUserGroup2UserByID 错误信息：" + ex.Message);
return(null);
}
}
private object GetEditObject(UltraGridRow row)
{
UserGroup2User userGroup2User = this._UserFacade.CreateUserGroup2User();
userGroup2User.UserGroupCode = row.Cells.FromKey("UserGroupCode").Text;
userGroup2User.UserCode = row.Cells.FromKey("UserCode").Text;
userGroup2User.MaintainUser = this.GetUserCode();
return(userGroup2User);
}
private string[] FormatExportRecord(object obj)
{
UserGroup2User userGroup2User = (UserGroup2User)obj;
return(new string[] {
userGroup2User.UserCode,
userGroup2User.UserGroupCode,
userGroup2User.GetDisplayText("MaintainUser"),
FormatHelper.ToDateString(userGroup2User.MaintainDate),
FormatHelper.ToTimeString(userGroup2User.MaintainTime)
});
}
private UltraGridRow GetGridRow(object obj)
{
UserGroup2User userGroup2User = (UserGroup2User)obj;
return(new UltraGridRow(
new object[] {
"false",
userGroup2User.UserCode,
userGroup2User.UserGroupCode,
userGroup2User.GetDisplayText("MaintainUser"),
FormatHelper.ToDateString(userGroup2User.MaintainDate),
FormatHelper.ToTimeString(userGroup2User.MaintainTime)
}));
}
protected override object GetEditObject(GridRecord row)
{
if (facade == null)
{
facade = new SystemSettingFacadeFactory(base.DataProvider).CreateUserFacade();
}
UserGroup2User relation = facade.CreateUserGroup2User();
relation.UserGroupCode = this.txtUserGroupCodeQuery.Text.Trim();
relation.UserCode = row.Items.FindItemByKey("UserCode").Text;
relation.MaintainUser = this.GetUserCode();
return relation;
}
public bool UpdateUserGroup2User(UserGroup2User ur)
{
this.checkUrl();
try
{
return(this.service.UpdateUserGroup2User(ur));
}
catch
{
try
{
return(this.service.UpdateUserGroup2User(ur));
}
catch (System.Exception ex)
{
LogService.WriteErr("UserSynchroWebService，地址是：" + this.service.Url + "方法： UpdateUserGroup2User 原因：" + ex.Message);
return(false);
}
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public static UserGroup2User DataRowToUserGroup2User(DataRow row)
{
UserGroup2User model = new UserGroup2User();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = new Guid(row["ID"].ToString());
}
if (row["UserGroupID"] != null && row["UserGroupID"].ToString() != "")
{
model.UserGroupID = new Guid(row["UserGroupID"].ToString());
}
if (row["UserID"] != null && row["UserID"].ToString() != "")
{
model.UserID = new Guid(row["UserID"].ToString());
}
}
return(model);
}
protected void cmdDelete_ServerClick(object sender, System.EventArgs e)
{
ArrayList rowArray = this._GridHelper.GetCheckedRows();
if (rowArray != null && rowArray.Count > 0)
{
ArrayList userGroup2UserArray = new ArrayList(rowArray.Count);
foreach (UltraGridRow row in rowArray)
{
UserGroup2User userGroup2User = (UserGroup2User)GetEditObject(row);
if (userGroup2User != null)
{
userGroup2UserArray.Add(userGroup2User);
}
}
this._UserFacade.DeleteUserGroup2User((UserGroup2User[])userGroup2UserArray.ToArray(typeof(UserGroup2User)));
this.RequestData();
this._ButtonHelper.PageActionStatusHandle(PageActionType.Delete);
}
}
public void DeleteUserGroup2User(UserGroup2User userGroup2User)
{
this._helper.DeleteDomainObject(userGroup2User);
}
public void UpdateUserGroup2User(UserGroup2User userGroup2User)
{
this._helper.UpdateDomainObject(userGroup2User);
}
public void AddUserGroup2User(UserGroup2User userGroup2User)
{
this._helper.AddDomainObject(userGroup2User);
}
