public ProType Update(ProType obj)
{
ProTypeBO protypeBO = new ProTypeBO(obj);
protypeDao.Update(protypeBO);
return(obj);
}
private void Color_button1_Click(object sender, EventArgs e)
{
ColorDialog colorDia = new ColorDialog();
if (colorDia.ShowDialog() == DialogResult.OK)
{
//获取所选择的颜色
Color colorChoosed = colorDia.Color;
var DiyR = colorChoosed.R.ToString();
var DiyG = colorChoosed.G.ToString();
var DiyB = colorChoosed.B.ToString();
var DiyA = colorChoosed.A.ToString();
// MessageBoxButtons messButton = MessageBoxButtons.OKCancel;
// DialogResult dr = MessageBox.Show(DiyR + "," + DiyG + "," + DiyB + "," + DiyA);
R.Text = DiyR;
G.Text = DiyG;
B.Text = DiyB;
A.Text = DiyA;
var Proinstance = nodeGraph2.Nodes[Member];
if (ProType.Equals("ADD"))
{
}
else
{
(Proinstance.Properties[EditedPropertise] as ZDProperty_Color).Value.R = colorChoosed.R;
(Proinstance.Properties[EditedPropertise] as ZDProperty_Color).Value.G = colorChoosed.G;
(Proinstance.Properties[EditedPropertise] as ZDProperty_Color).Value.B = colorChoosed.B;
(Proinstance.Properties[EditedPropertise] as ZDProperty_Color).Value.A = colorChoosed.A;
}
}
}
private void A_MouseMove(object sender, MouseEventArgs e)
{
if (Aispress)
{
Point point = A.PointToClient(Control.MousePosition);
if ((point.X + tempA) < 0)
{
A.Text = "0";
}
else if ((point.X + tempA) > 255)
{
A.Text = "255";
}
else
{
A.Text = (point.X + tempA).ToString();
var Proinstance = nodeGraph2.Nodes[Member];
if (ProType.Equals("ADD"))
{
}
else
{
(Proinstance.Properties[EditedPropertise] as ZDProperty_Color).Value.A = Convert.ToSingle(A.Text);
}
}
}
}
public async Task GenerateCode(ProType type, int durationDays, int useAmount, int codeAmount, string prefix, string id, int codeExpiresInDays, [Remainder] string str = "")
{
prefix = prefix == "0" ? null : prefix;
id = id == "0" ? null : id;
DateTime?expires = null;
if (codeExpiresInDays != 0)
{
expires = DateTime.Now.AddDays(codeExpiresInDays);
}
var res = await PremiumCodeDb.GenerateCodes(type, durationDays, useAmount, codeAmount, prefix, id, expires);
var example = res.FirstOrDefault();
string desc = "```yaml\n";
foreach (var prop in example.GetProperties())
{
desc += prop.Key + ": " + prop.Value + "\n";
}
desc += "```\n```yaml\n";
foreach (var code in res.Select(x => x.Id))
{
desc += code + "\n";
}
desc += "```";
await Context.Channel.SendMessageAsync(desc);
}
public static string SelectField(string FieldName, ProType typ, DBManagement DBMan)
{
if (typ == ProType.VNDATESTRING)
{
switch (DBMan)
{
case DBManagement.Access:
return string.Format("Format$({0},'dd/MM/yyyy') AS {0}", FieldName);
default:
return string.Format("Convert(varchar, {0}, 103) AS {0}", FieldName);
}
}
else
return FieldName;
}
private void ScaleZ_MouseMove(object sender, MouseEventArgs e)
{
if (ScaleZispress)
{
Point point = ScaleZ.PointToClient(Control.MousePosition);
ScaleZ.Text = (point.X + tempScaleZ).ToString();
var Proinstance = nodeGraph2.Nodes[Member];
if (ProType.Equals("ADD"))
{
}
else
{
(Proinstance.Properties[EditedPropertise] as ZDProperty_Transform).Value.Scale.Z = Convert.ToSingle(ScaleZ.Text);
}
}
}
private void RotationPitch_MouseMove(object sender, MouseEventArgs e)
{
if (RotationPitchispress)
{
Point point = RotationPitch.PointToClient(Control.MousePosition);
RotationPitch.Text = (point.X + tempRotationPitch).ToString();
var Proinstance = nodeGraph2.Nodes[Member];
if (ProType.Equals("ADD"))
{
}
else
{
(Proinstance.Properties[EditedPropertise] as ZDProperty_Transform).Value.Rotation.Pitch = Convert.ToSingle(RotationPitch.Text);
}
}
}
public static string IsDBNULL(object source, ProType typ, DBManagement DBMan)
{
if (source != null && !string.IsNullOrEmpty(source.ToString()))
{
if (typ == ProType.DATETIME || source is DateTime || source is DateTime?)
{
if (DBMan == DBManagement.Oracle)
{
return clsAll.Date2Oracle((DateTime)source);
}
else
{
return clsAll.Date2SQL((DateTime)source);
}
}
else
{
switch (typ)
{
case ProType.STRING:
if (DBMan == DBManagement.Access || DBMan == DBManagement.Oracle)
return string.Format("'{0}'", source);
else
return string.Format("N'{0}'", source);
case ProType.USDATESTRING:
return clsAll.DateEN2SQL(source.ToString());
case ProType.VNDATESTRING:
return clsAll.DateVN2SQL(source.ToString());
case ProType.BOOL:
if (DBMan == DBManagement.Access)
return clsAll.ConvertToBool(source.ToString()).ToString();
else
return clsAll.ConvertToBit(source.ToString()).ToString();
default:
if (!string.IsNullOrEmpty(source.ToString()))
return string.Format("{0:0.###############}", source);
else
return "NULL";
}
}
}
else
{
return "NULL";
}
}
public static async Task <IEnumerable <PremiumCode> > GenerateCodes(ProType type, int durationDays, int useAmount, int codeAmount, string prefix = null, string id = null, DateTime?expiresAt = null)
{
if (codeAmount > 1 && id != null)
{
throw new NamikoException("Only 1 code can be made with a custom id. Use prefix instead.");
}
if (codeAmount < 1)
{
throw new NamikoException("Amount must be >0");
}
if (durationDays < 1)
{
throw new NamikoException("DurationDays must be >0");
}
using var db = new NamikoDbContext();
var codes = new List <PremiumCode>();
for (int i = 0; i < codeAmount; i++)
{
var code = id ?? prefix ?? "";
if (id == null)
{
code += RandomString(8);
}
var item = new PremiumCode
{
CreatedAt = DateTime.Now,
ExpiresAt = expiresAt,
DurationDays = durationDays,
Type = type,
UsesLeft = useAmount,
Id = code
};
codes.Add(item);
}
db.PremiumCodes.AddRange(codes);
var res = await db.SaveChangesAsync();
return(codes);
}
public static object ToDBParam(object source, ProType typ, DBManagement DBMan)
{
if (source != null && !string.IsNullOrEmpty(source.ToString()))
{
//TuyenHM su dung parameter nen ko can convert nua
//if (typ == ProType.DATETIME || source is DateTime || source is DateTime?)
//{
// return clsAll.Date2SQL((DateTime)source);
//}
//else
//{
switch (typ)
{
case ProType.STRING:
return source;
case ProType.USDATESTRING:
DateTime? dtUS = clsAll.StringUSToDate(source.ToString());
if (dtUS == null)
return DBNull.Value;
else
return dtUS;
case ProType.VNDATESTRING:
DateTime? dtVN = clsAll.StringVNToDate(source.ToString());
if (dtVN == null)
return DBNull.Value;
else
return dtVN;
case ProType.DATETIME:
return (DateTime)source;
case ProType.BOOL:
if (DBMan == DBManagement.Access)
return clsAll.ConvertToBool(source.ToString());
else
return clsAll.ConvertToBit(source.ToString());
case ProType.NUMBER:
//TuyenHM
//return string.Format("{0:0.###############}", source);
return source;
default:
return source;
}
//}
}
else
{
return DBNull.Value;
}
}
public static object ToDBParam(object source, ProType typ)
{
return ToDBParam(source, typ, defaultDBMan);
}
public static string SelectField(string FieldName, ProType typ)
{
return SelectField(FieldName, typ, defaultDBMan);
}
public static string IsDBNULL(object source, ProType typ)
{
return IsDBNULL(source, typ, defaultDBMan);
}
public int Insert(ProType obj)
{
ProTypeBO protypeBO = new ProTypeBO(obj);
return(protypeDao.Insert(protypeBO));
}
//添加
private void Confirm_Edit(object sender, EventArgs e)
{
var ProName = PropertiseName.Text;
var Proinstance = nodeGraph2.Nodes[Member];
var ZDProType = nodeGraph2.Nodes[Member].Properties[EditedPropertise].DependencyObjectType.Name;
var properitem = (Member + "," + EditedPropertise + "," + ChoosedPropertise.Text).ToString();
if (ProType.Equals("ADD"))
{
switch (ZDProType)
{
case "ZDProperty_String":
if (EditedPropertise.Equals("NodeName"))
{
MessageBoxButtons messButton = MessageBoxButtons.OKCancel;
DialogResult dr = MessageBox.Show("不可修改NodeName,若要修改请联系管理员", "退出", messButton);
if (dr == DialogResult.OK) //如果点击“确定”按钮
{
this.Close();
}
else //如果点击“取消”按钮
{
this.Close();
}
}
else
{
// (Proinstance.Properties[EditedPropertise] as ZDProperty_String).Value = ChoosedPropertise.Text;
setFormTextValue(properitem);
//temp.FinalList.Items.Add(properitem);
}
this.Close();
break;
case "ZDProperty_Float":
// (Proinstance.Properties[EditedPropertise] as ZDProperty_Float).Value = Convert.ToSingle(ChoosedPropertise.Text);
setFormTextValue(properitem);
this.Close();
break;
case "ZDProperty_Boolean":
var tbool = false;
if (BooleanStatus.Text.Equals("true"))
{
tbool = true;
}
// (Proinstance.Properties[EditedPropertise] as ZDProperty_Boolean).Value = tbool;
var Boolproperitem = (Member + "," + EditedPropertise + "," + tbool).ToString();
setFormTextValue(Boolproperitem);
this.Close();
break;
case "ZDProperty_Integer":
// (Proinstance.Properties[EditedPropertise] as ZDProperty_Integer).Value = Convert.ToInt32(ChoosedPropertise.Text);
this.Close();
setFormTextValue(properitem);
break;
case "ZDProperty_Transform":
/* (Proinstance.Properties[EditedPropertise] as ZDProperty_Transform).Value.Location.X = Convert.ToSingle(LocationX.Text);
* (Proinstance.Properties[EditedPropertise] as ZDProperty_Transform).Value.Location.Y = Convert.ToSingle(LocationY.Text);
* (Proinstance.Properties[EditedPropertise] as ZDProperty_Transform).Value.Location.Z = Convert.ToSingle(LocationZ.Text);
* (Proinstance.Properties[EditedPropertise] as ZDProperty_Transform).Value.Rotation.Roll = Convert.ToSingle(RotationRoll.Text);
* (Proinstance.Properties[EditedPropertise] as ZDProperty_Transform).Value.Rotation.Yaw = Convert.ToSingle(RotationYaw.Text);
* (Proinstance.Properties[EditedPropertise] as ZDProperty_Transform).Value.Rotation.Pitch = Convert.ToSingle(RotationPitch.Text);
* (Proinstance.Properties[EditedPropertise] as ZDProperty_Transform).Value.Scale.X = Convert.ToSingle(ScaleX.Text);
* (Proinstance.Properties[EditedPropertise] as ZDProperty_Transform).Value.Scale.Y = Convert.ToSingle(ScaleY.Text);
* (Proinstance.Properties[EditedPropertise] as ZDProperty_Transform).Value.Scale.Z = Convert.ToSingle(ScaleZ.Text);*/
var Transproperitem = (Member + "," + EditedPropertise + "," + LocationX.Text + "," + LocationY.Text + "," + LocationZ.Text + "," + RotationRoll.Text + "," + RotationYaw.Text + "," + RotationPitch.Text + "," + ScaleX.Text + "," + ScaleY.Text + "," + ScaleZ.Text).ToString();
setFormTextValue(Transproperitem);
this.Close();
break;
case "ZDProperty_Color":
/* (Proinstance.Properties[EditedPropertise] as ZDProperty_Color).Value.R = Convert.ToSingle(R.Text);
* (Proinstance.Properties[EditedPropertise] as ZDProperty_Color).Value.G = Convert.ToSingle(G.Text);
* (Proinstance.Properties[EditedPropertise] as ZDProperty_Color).Value.B = Convert.ToSingle(B.Text);
* (Proinstance.Properties[EditedPropertise] as ZDProperty_Color).Value.A = Convert.ToSingle(A.Text);*/
var Colorproperitem = (Member + "," + EditedPropertise + "," + R.Text + "," + G.Text + "," + B.Text + "," + A.Text).ToString();
setFormTextValue(Colorproperitem);
this.Close();
break;
default: break;
}
}
if (ProType.Equals("PREVIEW"))
{
switch (ZDProType)
{
case "ZDProperty_String":
if (EditedPropertise.Equals("NodeName"))
{
MessageBoxButtons messButton = MessageBoxButtons.OKCancel;
DialogResult dr = MessageBox.Show("不可修改NodeName,若要修改请联系管理员", "退出", messButton);
if (dr == DialogResult.OK) //如果点击“确定”按钮
{
this.Close();
}
else //如果点击“取消”按钮
{
this.Close();
}
}
else
{
(Proinstance.Properties[EditedPropertise] as ZDProperty_String).Value = ChoosedPropertise.Text;
// setFormTextValue(properitem);
//temp.FinalList.Items.Add(properitem);
}
// this.Close();
break;
case "ZDProperty_Float":
(Proinstance.Properties[EditedPropertise] as ZDProperty_Float).Value = Convert.ToSingle(ChoosedPropertise.Text);
// setFormTextValue(properitem);
// this.Close();
break;
case "ZDProperty_Boolean":
var tbool = false;
if (BooleanStatus.Text.Equals("true"))
{
tbool = true;
}
(Proinstance.Properties[EditedPropertise] as ZDProperty_Boolean).Value = tbool;
// var Boolproperitem = (Member + "," + EditedPropertise + "," + tbool).ToString();
// setFormTextValue(Boolproperitem);
// this.Close();
break;
case "ZDProperty_Integer":
(Proinstance.Properties[EditedPropertise] as ZDProperty_Integer).Value = Convert.ToInt32(ChoosedPropertise.Text);
// this.Close();
// setFormTextValue(properitem);
break;
case "ZDProperty_Transform":
(Proinstance.Properties[EditedPropertise] as ZDProperty_Transform).Value.Location.X = Convert.ToSingle(LocationX.Text);
(Proinstance.Properties[EditedPropertise] as ZDProperty_Transform).Value.Location.Y = Convert.ToSingle(LocationY.Text);
(Proinstance.Properties[EditedPropertise] as ZDProperty_Transform).Value.Location.Z = Convert.ToSingle(LocationZ.Text);
(Proinstance.Properties[EditedPropertise] as ZDProperty_Transform).Value.Rotation.Roll = Convert.ToSingle(RotationRoll.Text);
(Proinstance.Properties[EditedPropertise] as ZDProperty_Transform).Value.Rotation.Yaw = Convert.ToSingle(RotationYaw.Text);
(Proinstance.Properties[EditedPropertise] as ZDProperty_Transform).Value.Rotation.Pitch = Convert.ToSingle(RotationPitch.Text);
(Proinstance.Properties[EditedPropertise] as ZDProperty_Transform).Value.Scale.X = Convert.ToSingle(ScaleX.Text);
(Proinstance.Properties[EditedPropertise] as ZDProperty_Transform).Value.Scale.Y = Convert.ToSingle(ScaleY.Text);
(Proinstance.Properties[EditedPropertise] as ZDProperty_Transform).Value.Scale.Z = Convert.ToSingle(ScaleZ.Text);
// var Transproperitem = (Member + "," + EditedPropertise + "," + LocationX.Text + "," + LocationY.Text + "," + LocationZ.Text + "," + RotationRoll.Text + "," + RotationYaw.Text + "," + RotationPitch.Text + "," + ScaleX.Text + "," + ScaleY.Text + "," + ScaleZ.Text).ToString();
// setFormTextValue(Transproperitem);
// this.Close();
break;
case "ZDProperty_Color":
(Proinstance.Properties[EditedPropertise] as ZDProperty_Color).Value.R = Convert.ToSingle(R.Text);
(Proinstance.Properties[EditedPropertise] as ZDProperty_Color).Value.G = Convert.ToSingle(G.Text);
(Proinstance.Properties[EditedPropertise] as ZDProperty_Color).Value.B = Convert.ToSingle(B.Text);
(Proinstance.Properties[EditedPropertise] as ZDProperty_Color).Value.A = Convert.ToSingle(A.Text);
// var Colorproperitem = (Member + "," + EditedPropertise + "," + R.Text + "," + G.Text + "," + B.Text + "," + A.Text).ToString();
// setFormTextValue(Colorproperitem);
// this.Close();
break;
default: break;
}
}
}
